PL300 Microsoft Power BI Data
Analyst Associate Practice Exam 2026
edition with correct and accurate
answers
You plan to create a report in Power BI Desktop. You need to identify the type of
visualization that displays data as a set of nested rectangles. Which visualization should
you use? - Correct Answer: Treemap
You need to create a custom R visual by using Power BI Desktop. What do you need to
do first? - Correct Answer: Install R on your computer.
You need to create a custom Python visual by using Power BI Desktop.
What do you need to do first? - Correct Answer: Install Python on your computer.
You are editing a report in Power BI Desktop. You need to adjust the behavior of the
report by editing interactions. Which two types of interaction behavior can you change
between visuals? Each correct answer presents a complete solution. - Correct Answer:
Filter; Highlight
You need to create a bookmark that toggles the visibility of a visual. This bookmark
must only toggle the visibility state and perform no other action.
Which three configurations should you make? Each correct answer presents part of the
solution. - Correct Answer: Disable the Data option; Disable the Current Page option;
Enable the Display option
You need to create a visual that displays sales by employees, trending over months.
The visual must clearly show how employees are performing against each other and
have a ranking for each period. Which visual should you use? - Correct Answer: ribbon
chart
You plan to use Power BI Desktop to analyze sales data for products sold by your
company. You need to create a DAX formula that will list 10 best-selling products sorted
by their total sales. Which DAX function should you use? - Correct Answer: TOPN
You plan to create a report in Power BI Desktop that will display the relationship
between the number of orders and the number of orders shipped by product category.
You need to identify the visual that will clearly identify outliers in the data set by
displaying them away from the bulk of data. Which visual should you use? - Correct
Answer: Scatter
, You implement the Q&A feature in a report, so users can get answers to their questions
on their own. You need to improve your Q&A search capabilities for end-users. Which
two configurations can you add? Each correct answer presents a complete solution. -
Correct Answer: Add a linguistic schema to the dataset; Add synonyms to model fields.
You plan to build a Power BI report and apply conditional formatting to the columns
used by a visual. Which two visuals support conditional formatting functionality for the
report? Each correct answer presents a complete solution. - Correct Answer: Matrix;
Table
You have implemented role-based security that restricts access to a Power BI Desktop
semantic model for users who are assigned the role named Salespeople. You need to
validate that the implementation works. What should you do? - Correct Answer: In the
Report view, activate the View as feature.
You plan to use Power BI Desktop to analyze sales data of your company.
You need to identify two types of data you will be able to use for creating bins that group
the sales data. Which two data types should you identify? Each correct answer presents
a complete solution. - Correct Answer: Date/time; Numeric
You need to create a visual that will display information on a continuous axis. Which two
data types can be used to display a continuous axis on a visual? Each correct answer
presents a complete solution. - Correct Answer: Date; Decimal Number
You need to make changes to your data sources. Which three changes are supported
by the Data source settings in the Power Query Editor? Each correct answer presents a
complete solution. - Correct Answer: Clearing permissions; Editing permissions;
Modifying the file path
You plan to add data to Power BI Desktop from a new data source. You are evaluating
whether you should use the DirectQuery storage mode or the Import storage mode.
What are two benefits of using DirectQuery instead of Import? Each correct answer
presents a complete solution. - Correct Answer: Minimized local disk space usage; No
need for data refresh
When importing data from an Excel workbook into Power BI, you receive the error
message: "We couldn't find any data formatted as a table."
What should you do to resolve the error? - Correct Answer: In the Excel workbook,
select the data you want to import, create a table, and save the change.
From Power BI Desktop, you create a data source by importing an Excel file. You plan
to identify data anomalies within the data source. Which interface should you use to
display the column quality feature and column distribution graph? - Correct Answer:
Power Query Editor
Analyst Associate Practice Exam 2026
edition with correct and accurate
answers
You plan to create a report in Power BI Desktop. You need to identify the type of
visualization that displays data as a set of nested rectangles. Which visualization should
you use? - Correct Answer: Treemap
You need to create a custom R visual by using Power BI Desktop. What do you need to
do first? - Correct Answer: Install R on your computer.
You need to create a custom Python visual by using Power BI Desktop.
What do you need to do first? - Correct Answer: Install Python on your computer.
You are editing a report in Power BI Desktop. You need to adjust the behavior of the
report by editing interactions. Which two types of interaction behavior can you change
between visuals? Each correct answer presents a complete solution. - Correct Answer:
Filter; Highlight
You need to create a bookmark that toggles the visibility of a visual. This bookmark
must only toggle the visibility state and perform no other action.
Which three configurations should you make? Each correct answer presents part of the
solution. - Correct Answer: Disable the Data option; Disable the Current Page option;
Enable the Display option
You need to create a visual that displays sales by employees, trending over months.
The visual must clearly show how employees are performing against each other and
have a ranking for each period. Which visual should you use? - Correct Answer: ribbon
chart
You plan to use Power BI Desktop to analyze sales data for products sold by your
company. You need to create a DAX formula that will list 10 best-selling products sorted
by their total sales. Which DAX function should you use? - Correct Answer: TOPN
You plan to create a report in Power BI Desktop that will display the relationship
between the number of orders and the number of orders shipped by product category.
You need to identify the visual that will clearly identify outliers in the data set by
displaying them away from the bulk of data. Which visual should you use? - Correct
Answer: Scatter
, You implement the Q&A feature in a report, so users can get answers to their questions
on their own. You need to improve your Q&A search capabilities for end-users. Which
two configurations can you add? Each correct answer presents a complete solution. -
Correct Answer: Add a linguistic schema to the dataset; Add synonyms to model fields.
You plan to build a Power BI report and apply conditional formatting to the columns
used by a visual. Which two visuals support conditional formatting functionality for the
report? Each correct answer presents a complete solution. - Correct Answer: Matrix;
Table
You have implemented role-based security that restricts access to a Power BI Desktop
semantic model for users who are assigned the role named Salespeople. You need to
validate that the implementation works. What should you do? - Correct Answer: In the
Report view, activate the View as feature.
You plan to use Power BI Desktop to analyze sales data of your company.
You need to identify two types of data you will be able to use for creating bins that group
the sales data. Which two data types should you identify? Each correct answer presents
a complete solution. - Correct Answer: Date/time; Numeric
You need to create a visual that will display information on a continuous axis. Which two
data types can be used to display a continuous axis on a visual? Each correct answer
presents a complete solution. - Correct Answer: Date; Decimal Number
You need to make changes to your data sources. Which three changes are supported
by the Data source settings in the Power Query Editor? Each correct answer presents a
complete solution. - Correct Answer: Clearing permissions; Editing permissions;
Modifying the file path
You plan to add data to Power BI Desktop from a new data source. You are evaluating
whether you should use the DirectQuery storage mode or the Import storage mode.
What are two benefits of using DirectQuery instead of Import? Each correct answer
presents a complete solution. - Correct Answer: Minimized local disk space usage; No
need for data refresh
When importing data from an Excel workbook into Power BI, you receive the error
message: "We couldn't find any data formatted as a table."
What should you do to resolve the error? - Correct Answer: In the Excel workbook,
select the data you want to import, create a table, and save the change.
From Power BI Desktop, you create a data source by importing an Excel file. You plan
to identify data anomalies within the data source. Which interface should you use to
display the column quality feature and column distribution graph? - Correct Answer:
Power Query Editor
