EN简体繁體
Sign in
Home / Microsoft / PL-300
Microsoft · PL-300

PL-300 Exam Practice Questions

Microsoft Power BI Data Analyst

PL-300 English PDF practice questions: 397 questions in source order, with options supported by the source format, answers and available explanations. Access covers this exam only. One-time payment; no automatic renewal.

Exam overview

For Power BI analysts preparing and modeling data, creating visual insights, and managing analytical content securely.

Exam code
PL-300
Official exam / credential
Microsoft Power BI Data Analyst
Exam format
Proctored assessment; interactive items may be included
Exam duration
100 minutes
Official exam languages
English, Japanese, Simplified Chinese, Korean, German, French, Spanish, Portuguese (Brazil), Traditional Chinese, Italian

Official exam languages and practice-question file languages are listed separately. Confirm the exam version and available languages when booking with the provider.

Official sources: Provider reference
Information checked: 2026-10-20

Supported languages

  • English
  • Simplified Chinese
  • Japanese
Try before you buy

First 20 practice questions

397 total questions

Questions follow the source order. Expand each answer to see its explanation.

Disclaimer: All questions on ExamPico are compiled from internet sources and are provided for study reference only.

Question 11

Question#11Topic1

You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI dataset.
You need to ensure that the dataset can be refreshed in powerbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  1. A. Excel Workbook
  2. B. Text/CSV
  3. C. Folder
  4. D. SharePoint folder
  5. E. Web
Show answer and explanation

Answer

DE

Explanation

A, B, C: wrong! Would work technically, but the connection will be only to the local copy of the file, no refresh from the online version stored on OneDrive D: correct, but more complicated than option E E: correct, this is the best option to import from OneDrive

Question 12

Question#12Topic1

HOTSPOT -
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in the following exhibit.
Question illustration
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.
Hot Area:
Question illustration

Show answer and explanation

Answer

CA

Explanation

Box 1: 69 -
69 distinct/different values.
Note: Column Distribution allows you to get a sense for the overall distribution of values within a column in your data previews, including the count of distinct values (total number of different values found in a given column) and unique values (total number of values that only appear once in a given column).

Box 2: 4 -
Reference:
https://systemmanagement.ro/2018/10/16/power-bi-data-profiling-distinct-vs-unique/

Question 13

Question#13Topic1

HOTSPOT -
You have two CSV files named Products and Categories.
The Products file contains the following columns:
✑ ProductID
✑ ProductName
✑ SupplierID
✑ CategoryID
The Categories file contains the following columns:
✑ CategoryID
✑ CategoryName
✑ CategoryDescription
From Power BI Desktop, you import the files into Power Query Editor.
You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:
✑ ProductID
✑ ProductName
✑ SupplierID
✑ CategoryID
✑ CategoryName
✑ CategoryDescription
How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Question illustration

Show answer and explanation

Answer

BB

Explanation

Box 1: Merge -
There are two primary ways of combining queries: merging and appending.
* When you have one or more columns that you'd like to add to another query, you merge the queries.
* When you have additional rows of data that you'd like to add to an existing query, you append the query.

Box 2: Disable the query load -

Managing loading of queries -
In many situations, it makes sense to break down your data transformations in multiple queries. One popular example is merging where you merge two queries into one to essentially do a join. In this type of situations, some queries are not relevant to load into Desktop as they are intermediate steps, while they are still required for your data transformations to work correctly. For these queries, you can make sure they are not loaded in Desktop by un-checking 'Enable load' in the context menu of the query in Desktop or in the Properties screen:
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-include-in-report-refresh

Question 14

Question#14Topic1

You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?

  1. A. Add a SQL statement.
  2. B. Set the Command timeout in minutes setting.
  3. C. Set Data Connectivity mode to Import.
  4. D. Set Data Connectivity mode to DirectQuery.
Show answer and explanation

Answer

D

Explanation

DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi- dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Question 15

Question#15Topic1

DRAG DROP -
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files.
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.
Select and Place:
Question illustration

Show answer and explanation

Answer

ACB

Explanation

A, C, B From Power BI Desktop, select Get Data, and then select Folder. From Power Query Editor, remove the Content column. From Power Query Editor, expand the Attributes column.

Downloads and personal use

  • Purchase this exam question set separately with 1, 3, 6 or 12 months of download access.
  • After payment confirmation, your library shows the download link and exact expiry time.
  • Download again during your term. Purchase a new term after expiry.
  • PDFs are licensed for personal study only and must not be resold or shared publicly.
  • Files already saved to your device are not remotely deleted when access expires.
How to choose your certification