Pass PL-300 Exam Guide

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?

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report

You need to recommend a solution to improve the performance of the report.

What should you recommend?

You have a Power BI report that contains one page. The page contains two line charts and one bar chart.

You need to ensure that users can perform the following tasks for all three visuals:

Switch the measures used in the visuals.

Change the visualization type.

Add a legend.

The solution must minimize development effort.

What should you do?

You have a semantic model that contains a table named Sales. The table contains the following columns;

• Order ID

• Product ID

• Sales Dote

• Sales Amount

You need to create a DAX measure that will return the total sales amount for the same dates from the previous year. How should you complete the measure? To answer, select the appropriate options m the answer area.

NOTE: Each correct selection is worth one point.