PL-300 Exam Dumps - Microsoft Power BI Data Analyst

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?

You have the following table named Location.

The GeoCode column represents the country where each customer is located.

You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations.

What should you do?

Each Region value appears only on the tow where it first occurred. Each subsequent occurrence of the Region value is blank.

You need to ensure that every row contains the connect non-blank value The solution must minimize development effort.

Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area. NOTE; Each connect selection is worth one point.

You attempt to open a PBiX file in Microsoft Power Bl Desktop and receive the following error message in Power Query Editor.

DataSource. Error: Could of not find file D:\Data.txt.

How should you resolve the issue?

You have a semantic model named Model1.

You have a Power BI report named RPT1 that is connected to Model1. RPT1 contains a table visual named Table1 that shows the results of multiple measures.

You discover that the DAX query for Table1 runs slowly.

You need to identify which measure is slowing query performance.

What should you use?

You have a Power B1 semantic model.

You need to create a column that will contain year over year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year's monthly revenue.

How should you complete the OAX formula? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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

You need to make the visual more accessible to users who have color vision deficiency.

What should you do?

You are creating a dashboard by using the Power Bl service.

You have an existing report page that contains three charts.

You need to add the charts to the dashboard while maintaining the interactivity between the charts.

What should you do?