Microsoft Certified: Power BI Data Analyst Associate Questions and Answers

200 questions organized by topic with detailed explanations

Microsoft

PL-300

200 questions

4 topics

Updated May 2026

Prepare the data

55 questions16 easy27 medium12 hard~28% of exam

A report author needs visuals to query source data when users interact with the report instead of storing the table data...A developer needs to merge two tables by CountryID and StateID. What must be true when selecting multiple join columns?In Power Query, which merge join kind returns all rows from the left table and only matching rows from the right table?

Model the data

53 questions13 easy27 medium13 hard~27% of exam

A modeler wants to inspect the DAX query generated by a report visual and then modify it in a richer editor. Which pair ...Which validation is required when marking your own date table in Power BI Desktop?A semantic model has an inactive ShipDate relationship and an active OrderDate relationship. Which DAX function should a...

Visualize and analyze the data

55 questions14 easy28 medium13 hard~27% of exam

A team wants users to sort, filter, and personalize a visual calculation after publishing. What should the modeler know?A consumer changes a visual through personalization and wants to return to the same customized view later. What should t...What is required for cross-report drillthrough to work?

Manage and secure Power BI

37 questions8 easy17 medium12 hard~18% of exam

In a Power BI app, what is the risk of enabling Allow access to hidden content?Where are RLS role definitions created and where are users assigned to those roles?Which workspace role should you assign if a user needs read-only access and should still be subject to RLS?

All Questions

#	Question	Topic	Difficulty
1	A report author needs visuals to query source data when users interact with the report instead of st...	Prepare the data	easy
2	A modeler wants to inspect the DAX query generated by a report visual and then modify it in a richer...	Model the data	medium
3	A team wants users to sort, filter, and personalize a visual calculation after publishing. What shou...	Visualize and analyze the data	hard
4	In a Power BI app, what is the risk of enabling Allow access to hidden content?	Manage and secure Power BI	medium
5	A developer needs to merge two tables by CountryID and StateID. What must be true when selecting mul...	Prepare the data	medium

Sign in to see all 200 questions

Create a free account to browse all questions — completely free during our launch phase.

Sign Up Free Sign In

Ready to test your knowledge?

Take a full Microsoft Certified: Power BI Data Analyst Associate practice test with timed exam simulation.

Start Practice Test