Microsoft Power BI Data Analyst (PL-300) Exam Practice Questions & Study Guide 2026

Question 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports Solution: In Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. you create a group that contains all the users. You share each selected report and the one dashboard to the group. Does this meet the goal?

A. Yes 
B. No 

Show Answer

Question 2

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis. What should you do?

A. Get data from a SharePoint folder, enter the site URL and then select Combine & Load 
B. Get data from a SharePoint list and enter the site URL Select Combine & Transform, then filter by the folder path to the manufacturing reports library. 
C. Get data from a SharePoint list enter the site URL and then select Combine & Load 
D. Get data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library,

Show Answer

Question 3

You have a Power Bl app that contains a report named Report1. You add a new page to Report1. You need to ensure that users can view the new page. The solution must minimize administrative effort. What should you do? 

A. Update the audience in the app. 
B. Update the app. 
C. Update the contact information in the app
D. Unpublish and create a new app. 

Show Answer

Question 4

A user creates a Power B1 report named ReportA that uses a custom theme You create a dashboard named DashboardA. You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. From DashboardA upload a JSON theme. 
B. Publish ReportA to the Microsoft Power B1 Community theme gallery. 
C. From DashboardA create a custom theme. 
D. From ReportA save the current theme. 
E. Publish ReportA to Power Bl. 

Show Answer

Question 5

You have a Microsoft Excel file on a file server. You create a Power BI report and import a table from the Excel file. You publish the report. You need to ensure that the data refreshes every four hours. What should you do first?

A. Upload the Excel file to a Power BI workspace.
 B. Create a subscription to the report. 
C. Deploy an on-premises data gateway. 
D. Edit the data source credentials. 

Show Answer

Question 6

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode. Solution: You create aggregations to summarize results. Does this meet the goal?

A. Yes 
B. No 

Show Answer

Question 7

You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You change the semantic model mode. Does this meet the goal?

A. Yes 
B. No 

Show Answer

Question 8

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys: • Due Date • Order Date • Delivery Date You need to support the analysis of sales over time based on all three dates at the same time. Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table. Does this meet the goal?

A. Yes 
B. No 

Show Answer

Question 9

You have a semantic model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns: • Date • Product • SalesAmount You need to create a DAX measure for a rolling 31 -day sales total that will return the total sales amount for a selected date and the previous 30 days. Which DAX expression should you use?

A. CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date],Max('Date'[Date])-36, Max('Date'[Date])))
B. CALCUlATE(SUM<Sales[SalesAmountJ), 0ATEA00(Date[Date], -36, DAY))
C. CALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)
D. CALCULATE(SUM(Sales[SalesAmount]), DATESHTD(Date[Date]))

Show Answer

Question 10

Vou plan to create a Power B1 report that will be connected to multiple data sources. One of the data sources contains law records. You need to ensure that other queries cannot access the tax record Information. To what should you set Privacy Level for the data source?

A. None 
B. Private 
C. Organizational 
D. Public 

Show Answer