Microsoft PL-300 Microsoft Power BI Data Analyst Exam Practice Test

You have a data source that contain a column. The column contains case sensitive data.

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 implicitly convert the values into the required types.

Does this meet the goal?

You have a Power B1 report that contains one visual

You need to provide users with the ability to change the visual type without affecting the view for other users. What should you do?

You create a Power Bl report1 named Summary1 You discover that Summary1 is slow.

You run Performance analyzer to identify performance metrics for Summary1

Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.

You have a Power Bl report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

You have a Microsoft 365 subscription that contains the resources shown in the following table.

You create a new dashboard that uses row-level security (RIS) filters You define a new role named Consultants.

To which resource can you assign the Consultants role?

In Power BI Desktop, you have a dataset that contains a table.

You create a table visual on a Power BI report page as shown in the following exhibit

You need to configure the visual to display the referenced image instead of the URL in the Plant Image column.

What should you do?

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

* If the discount column returns an error, a discount of 0.05 must be used.

* All the rows of data must be maintained.

* Administrative effort must be minimized.

What should you do in Power Query Editor?