PL-300: Microsoft Power BI Data
Analyst Exam Actual Questions and
Answers 2026
Question #14Topic 1
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?
A. Add a SQL statement.
B. Set the Command timeout in minutes setting.
C. Set Data Connectivity mode to Import.
D. Set Data Connectivity mode to DirectQuery. -
correct answer ✅D. Set Data Connectivity mode to DirectQuery.
Reference:https://docs.microsoft.com/en-us/power-bi/connect-
data/desktop-use-directquery
Question #16Topic 1
A business intelligence (BI) developer creates a dataflow in Power
BI that uses DirectQuery to access tables from an on-premises
,PL-300: Microsoft Power BI Data
Analyst Exam Actual Questions and
Answers 2026
Microsoft SQL server. TheEnhanced Dataflows Compute Engine is
turned on for the dataflow.You need to use the dataflow in a report.
The solution must meet the following requirements:
✑ Minimize online processing operations.
✑ Minimize calculation times and render times for visuals.
✑ Include data from the current year, up to and including the
previous day.
What should you do?
A. Create a dataflows connection that has DirectQuery mode
selected.
B. Create a dataflows connection that has DirectQuery mode
selected and configure a gateway connection for the dataset.
C. Create a dataflows connection that has Import mode selected
and schedule a daily refresh.
D. Create a dataflows connection that has Import mode selected
and create a Microsoft Power Automate solution to refres -
correct answer ✅C. Create a dataflows connection that has Import
mode selected and schedule a daily refresh.
2.3
,PL-300: Microsoft Power BI Data
Analyst Exam Actual Questions and
Answers 2026
For the sales department at your company, you publish a Power BI
report that imports data from a Microsoft Excel file located in a
Microsoft SharePoint folder.
The data model contains several measures.
You need to create a Power BI report from the existing data. The
solution must minimize development effort.
Which type of data source should you use?
A. Power BI dataset
B. a SharePoint folder
C. Power BI dataflows
D. an Excel workbook -
correct answer ✅A. Power BI dataset
You are building a Power BI report that uses data from an Azure SQL
database named erp1.You import the following tables.
You need to perform the following analyses:
, PL-300: Microsoft Power BI Data
Analyst Exam Actual Questions and
Answers 2026
✑ Orders sold over time that include a measure of the total order
value
Orders by attributes of products sold
The solution must minimize update times when interacting with
visuals in the report.What should you do first?
A. From Power Query, merge the Order Line Items query and the
Products query.
B. Create a calculated column that adds a list of product categories
to the Orders table by using a DAX function.
C. Calculate the count of orders per product by using a DAX
function.
D. From Power Query, merge the Orders query and the Order Line
Items query. -
correct answer ✅D. From Power Query, merge the Orders query
and the Order Line Items query.
2.5
You have a CSV file that contains user complaints. The file contains
a column named Logged. Logged contains the date and time each
Analyst Exam Actual Questions and
Answers 2026
Question #14Topic 1
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?
A. Add a SQL statement.
B. Set the Command timeout in minutes setting.
C. Set Data Connectivity mode to Import.
D. Set Data Connectivity mode to DirectQuery. -
correct answer ✅D. Set Data Connectivity mode to DirectQuery.
Reference:https://docs.microsoft.com/en-us/power-bi/connect-
data/desktop-use-directquery
Question #16Topic 1
A business intelligence (BI) developer creates a dataflow in Power
BI that uses DirectQuery to access tables from an on-premises
,PL-300: Microsoft Power BI Data
Analyst Exam Actual Questions and
Answers 2026
Microsoft SQL server. TheEnhanced Dataflows Compute Engine is
turned on for the dataflow.You need to use the dataflow in a report.
The solution must meet the following requirements:
✑ Minimize online processing operations.
✑ Minimize calculation times and render times for visuals.
✑ Include data from the current year, up to and including the
previous day.
What should you do?
A. Create a dataflows connection that has DirectQuery mode
selected.
B. Create a dataflows connection that has DirectQuery mode
selected and configure a gateway connection for the dataset.
C. Create a dataflows connection that has Import mode selected
and schedule a daily refresh.
D. Create a dataflows connection that has Import mode selected
and create a Microsoft Power Automate solution to refres -
correct answer ✅C. Create a dataflows connection that has Import
mode selected and schedule a daily refresh.
2.3
,PL-300: Microsoft Power BI Data
Analyst Exam Actual Questions and
Answers 2026
For the sales department at your company, you publish a Power BI
report that imports data from a Microsoft Excel file located in a
Microsoft SharePoint folder.
The data model contains several measures.
You need to create a Power BI report from the existing data. The
solution must minimize development effort.
Which type of data source should you use?
A. Power BI dataset
B. a SharePoint folder
C. Power BI dataflows
D. an Excel workbook -
correct answer ✅A. Power BI dataset
You are building a Power BI report that uses data from an Azure SQL
database named erp1.You import the following tables.
You need to perform the following analyses:
, PL-300: Microsoft Power BI Data
Analyst Exam Actual Questions and
Answers 2026
✑ Orders sold over time that include a measure of the total order
value
Orders by attributes of products sold
The solution must minimize update times when interacting with
visuals in the report.What should you do first?
A. From Power Query, merge the Order Line Items query and the
Products query.
B. Create a calculated column that adds a list of product categories
to the Orders table by using a DAX function.
C. Calculate the count of orders per product by using a DAX
function.
D. From Power Query, merge the Orders query and the Order Line
Items query. -
correct answer ✅D. From Power Query, merge the Orders query
and the Order Line Items query.
2.5
You have a CSV file that contains user complaints. The file contains
a column named Logged. Logged contains the date and time each
