PL-300 study guide: Power BI Data Analyst exam domains, plan and common mistakes
Written and reviewed by the DevOpsCode Lab Team. Last updated 19 November 2026.
PL-300 is the exam for the Microsoft Certified: Power BI Data Analyst Associate certification. It checks that you can take data from source to shared report in Power BI: connect and clean data in Power Query, build a semantic model with relationships and DAX, design reports and dashboards, and publish, share and secure content in the Power BI service.
What the exam tests
PL-300 is practical. Questions show a data source, a model diagram, a DAX formula or a report requirement and ask what to do next: which transformation, which relationship setting, which DAX function, which visual or which workspace role. Knowing the menu names in Power BI Desktop and the Power BI service matters, because answers often differ by one setting.
Domains and how much each counts
| Domain | Weight | What to be able to do | Questions in our bank |
|---|---|---|---|
| Prepare the data | 28% | Connect to sources and pick a storage mode (Import, DirectQuery, Dual); profile data with column quality and distribution; clean, shape, merge and append queries in Power Query; resolve data type and error issues | 67 |
| Model the data | 27% | Design a star schema with fact and dimension tables; set relationship cardinality and cross-filter direction; write measures and calculated columns in DAX, including CALCULATE and time intelligence; optimize model size and performance | 64 |
| Visualize and analyze the data | 28% | Choose and format visuals; use slicers, filters, drill-through, bookmarks and tooltips; design for accessibility and mobile; use analytics features such as key influencers, anomaly detection and Q&A | 67 |
| Manage and secure Power BI | 17% | Create and manage workspaces and roles; publish apps; schedule refresh and configure gateways; apply row-level security and sensitivity labels; share and distribute content | 42 |
The first three domains carry almost equal weight. Manage and secure is the smallest, but row-level security and workspace roles come up often and are easy points once you learn them.
Exam format
Our practice tests use 50 questions in 100 minutes with a 70% pass mark. Microsoft reports results on a 1–1000 scale with 700 to pass, and the live exam can include case studies and question types that do not let you go back. Check the official Microsoft exam page for the current format, price and objectives before you book.
Who should take it
- Analysts who build Power BI reports and want a certification that matches the work.
- Excel power users moving to Power BI for shared, refreshable reporting.
Hands-on Power BI Desktop time is the most important preparation. Reading about DAX without writing measures rarely sticks.
A 4-week study plan
| Week | Focus | Practice |
|---|---|---|
| 1 | Prepare the data: connectors, storage modes, data profiling, Power Query transforms, merge versus append, query folding basics | Practice mode on this domain; take one full test at the end of the week as a baseline |
| 2 | Model the data: star schema, relationships, cardinality and filter direction, measures versus calculated columns, CALCULATE, filter context, time intelligence, role-playing dimensions | Domain quiz for modeling; rebuild every wrong DAX answer in Power BI Desktop |
| 3 | Visualize and manage: visual choice, interactions, drill-through, bookmarks, workspaces and roles, apps, refresh and gateways, RLS | Two domain quizzes; test RLS with “View as” in Desktop |
| 4 | Full exams and weak areas | Two full timed tests, then the mistakes quiz; book the exam when you score 80%+ twice |
Topics people often get wrong
- Measures versus calculated columns. A calculated column is computed at refresh, row by row, and stored in the model; a measure is computed at query time in the current filter context. Use measures for aggregations that must respond to slicers.
- Merge versus append. Merge joins two queries side by side on matching columns, like a SQL join; append stacks rows from queries with the same columns, like a union.
- Import, DirectQuery and Dual. Import copies data into the model and is fastest; DirectQuery sends queries to the source for near real-time data with limits on transforms and DAX; Dual lets a table act as either, which helps in composite models.
- Cross-filter direction. Single direction from dimension to fact is the default and the safe choice; bidirectional filtering can cause ambiguity and slow models, so use it only when needed.
- Workspace roles versus row-level security. Workspace roles (Admin, Member, Contributor, Viewer) control what people can do with content; RLS limits which rows they see. RLS filters apply to Viewers, not to users who can edit the dataset.
How to use the practice tests
Start with the free PL-300 questions to see the style. Then take one full timed test in exam mode for a baseline and look at the score by domain. Spend most of your time in the two weakest domains with domain quizzes, and finish with the mistakes quiz before each new full test. The readiness number tells you when your recent scores hold above the pass mark across all domains.
Frequently asked questions
How hard is PL-300? It is an associate exam. People who already build Power BI reports usually need 3–4 weeks of focused practice; those new to DAX often need 6 or more.
How much DAX do I need? You need to read and choose correct measures, especially with CALCULATE, FILTER, ALL and time intelligence functions. You do not need to write very long formulas from memory.
How long is the certification valid? Microsoft role-based certifications are valid for one year and can be renewed with a free online assessment on Microsoft Learn.
Are these the real exam questions? No. Every question is written by us for the published skills outline. We never use leaked or recalled exam content.
DevOpsCode Lab is not affiliated with or endorsed by Microsoft. Exam names are trademarks of their owners. Check the official Microsoft exam page for the current price, format and objectives before you book.