Home
Microsoft
PL-300: Microsoft Power BI Data Analyst Dumps

Free Microsoft PL-300 Exam Dumps April 2026

Here you can find all the free questions related with Microsoft Power BI Data Analyst (PL-300) exam. You can also find on this page links to recently updated premium files with which you can practice for actual Microsoft Power BI Data Analyst Exam. These premium versions are provided as PL-300 exam practice tests, both as desktop software and browser based application, you can use whatever suits your style. Feel free to try the Microsoft Power BI Data Analyst Exam premium files for free, Good luck with your Microsoft Power BI Data Analyst Exam.

Question No: 1

MultipleChoice

Your company has training videos that are published to Microsoft Stream.

You need to surface the videos directly in a Microsoft Power BI dashboard.

Which type of tile should you add?

Options

Avideo

Bcustom streaming data

Ctext box

Dweb content

Answer
DExplanation

https://docs.microsoft.com/en-us/stream/portal-embed-video

https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content

Question No: 2

MultipleChoice

You are creating a Power BI model that contains a table named Store. Store contains the following fields.

You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?

Options

ASet the data category of City. State/Province, and Country.

BSet Summarization for City. State/Province, and Country to Don't summarize

CChange the data type of City. State/Province, and Country.

DCreate a calculated column that concatenates the values it City, State/Province, and Country.

Answer
A

Question No: 3

OrderList

You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:

Identify months that have order counts above the mean.

Display the mean monthly order count.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer

Question No: 4

Hotspot

You are creating a line chart in a Power Bl report as shown in the following exhibit.

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

NOTE: Each correct selection is worth one point.

Answer

Question No: 5

Hotspot

Your company has affiliates who help the company acquire customers.

You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.

The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

You need to develop a measure to support the visual.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Answer

Explanation

https://docs.microsoft.com/en-us/dax/topn-function-dax

Question No: 6

Hotspot

You have a Power B1 model that contains a table named Date. The table has the following columns.

Answer is below.

Answer

Question No: 7

Hotspot

You have a Power 31 data model that contains a table named Stores. The table has the following columns:

* Store Name

* Open Date

* Status

* State

* City

You need to create a calculated column named Active Store Name that meets the following requirements:

Answer is as below

Answer

Question No: 8

Hotspot

You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.

You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

* Create reports that use the HR dataset.

* Publish the reports to WorkspaceB.

* Prevent the ability to modify the HR dataset.

* Prevent the ability to add users to WorkspaceB.

Answer is as below.

Answer

Question No: 9

DragDrop

You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.

You add a sheer named Country to each page of the report.

You need to configure the report to meet the following requirements:

* When a user selects a country on the first page, the report must filter the other pages.

* The second and third pages must display only the filtered results.

Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE Each correct selection is worth one point.

Answer

Question No: 10

Hotspot

You have a Power B1 model that contains a table named Date. The table has the following columns.

Answer

Question No: 11

Hotspot

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

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

NOTE: Each correct selection is worth one point.

Box 1: CALCULATE

Answer

Explanation

https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054

Question No: 12

Hotspot

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are

a. NOTE: Each correct selection is worth one point.

)

Answer

Explanation

https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

Question No: 13

Hotspot

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

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

NOTE: Each correct selection is worth one point.

Answer

Explanation

https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054

Question No: 14

Hotspot

You have a dataset named Pens that contains the following columns:

Unit Price

Quantity Ordered

You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.

Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Answer

Explanation

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

Question No: 15

MultipleChoice

The table has the following columns.

You need to add a column that will be used to sort the Year Month column chronologically.

Options

AOption A

BOption B

COption C

DOption D

Answer
A, DExplanation

Answer as.

You publish a dataset that contains data from an on-premises Microsoft SQL Server database.

The dataset must be refreshed daily.

You need to ensure that the Power BI service can connect to the database and refresh the dataset.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?

Question No: 16

Hotspot

You need to create a visualization to meet the reporting requirements of the sales managers.

HOW Should create the Visualization? TO answer, select the appropriate options in the answer are

Answer is as below:

Answer

Question No: 17

OrderList

You build a report about warehouse inventory dat

a. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.

You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer

Add a column named ProductName that contains only the text...Create a prodcut hierarchy of ProductCategory..Replace the use of ProductDescription in the report with the product hierarchy.

Question No: 18

MultipleChoice

You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.

You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

* Create reports that use the HR dataset.

* Publish the reports to WorkspaceB.

* Prevent the ability to modify the HR dataset.

* Prevent the ability to add users to WorkspaceB.

Options

AExplanation:
Answer is as below.

Answer
A

Question No: 19

MultipleChoice

You need to create a visualization to meet the reporting requirements of the sales managers.

HOW Should create the Visualization? TO answer, select the appropriate options in the answer are

Options

AExplanation:
Answer is as below:

Answer
A

Question No: 20

OrderList

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

Answer

From Power BI Desktope, import the data from Excel, and select Table1 and Table2.From Power Query Editor, append Table2 to Table1.From Powers Query Editor, select Table1, and then select Remove duplicates.

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF