Official Bank 0/464

Microsoft Power BI Data Analyst (PL-300) - Microsoft Exam Questions

Last updated on June 22, 2026

97% Exam Compliance
464 Total Questions
1
Question
following table. You have a table named DiMCountries that contains a column named Country as shown in the

Exhibit

You plan to use DiMCountnes as a dimension m a report. You new to ensure that the Country column in DiMCountnes lists each country only once. Which two actions should you perform on the Country column? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.
Select 2
Options
A Apply a clean transform.
B Change Data category to Country.
C Replace the empty fields.
D Apply a Capitalize Each Word transform.
E Remove duplicate values.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
You have a Power BI workspace named BI Data that contains a dataset named BI Finance. You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace, You need to connect to BI Finance and create a report.

Which actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.
Options
A From Power Bl Desktop, connect to a shared dataset
B From the Power BI service, create a dataflow to the dataset by using DirectQuery.
C From the Power BI service, create a new report and select a published dataset
D From Power BI Desktop, connect to a Dataverse data source.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
What should you do to address the existing environment data concerns?
Options
A a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0,
(Sales[sales_amount]))
B a calculated column that uses the following formula: ABS(Sales[sales_amount])
C a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
D a measure that uses the following formula: SUM(Sales[sales_amount])
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
You have a semantic model that has the permissions shown in the following exhibit. HOTSPOT

Exhibit

Use the drop-down menus to select the answer choice the that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Exhibit
Reveal Only
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard. You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.
Select 2
Options
A Pin the visual to the dashboard.
B Add the visual to the report.
C Use quick insights on the dashboard.
D Ask a question by using Q&A.
E Hide the report page.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.