To pass PL-300, work from Microsoft's official study guide and skills outline, learn by building reports in Power BI Desktop, and spend extra time on data modelling and DAX, which candidates often find hardest. Take Microsoft's free practice assessment, review every wrong answer, and space your revision over several weeks rather than cramming.
What does PL-300 cover?
PL-300 is the exam for the Microsoft Certified: Power BI Data Analyst Associate certification. It tests whether you can prepare data, model it, visualise and analyse it, and manage and secure Power BI assets. Microsoft publishes a study guide on Microsoft Learn with the skills measured and their weightings, and it sometimes lists two versions when the outline is about to change. Read the current version before you plan; third-party summaries can be out of date.
What makes PL-300 hard?
- Data modelling: star schemas, relationships, cardinality and filter direction.
- DAX: filter context, CALCULATE and time intelligence functions.
- Power Query: shaping and cleaning data, and knowing when to transform in Power Query versus DAX.
- Scenario questions that describe a business need and ask for the best option, not just a working one.
A six-week study plan
| Week | Focus | Practice |
|---|---|---|
| 1 | Get data and Power Query | Import and clean two messy datasets |
| 2 | Data modelling | Build a star schema from a flat table |
| 3 | DAX basics and CALCULATE | Write measures from a blank editor |
| 4 | Visuals and report design | Build a report for a stated business question |
| 5 | Deploy, share and secure | Workspaces, apps and row-level security |
| 6 | Review and practice assessment | Retake weak areas, timed practice |
How should you study the theory?
Much of PL-300 is applied, but the definitions and rules behind it have to be in memory: what a relationship's cross-filter direction does, the difference between a calculated column and a measure, how context transition works. Retrieval practice is the most efficient way to fix these. Write a measure without looking it up, explain a concept in your own words, then check.
Spacing matters as much as retrieval. Return to modelling and DAX each week instead of finishing them in week two and moving on (Cepeda et al., 2006).
What should go on your PL-300 flashcards?
- Calculated column versus measure: when each is evaluated and what each costs in model size.
- Relationship settings: cardinality, cross-filter direction and when bidirectional filtering causes ambiguity.
- What CALCULATE does to filter context, and what context transition means.
- Common time intelligence functions and the date table they need.
- Import, DirectQuery and composite models: the trade-offs in one line each.
- Workspace roles and row-level security: who can see and do what.
Which free official resources should you use?
- The PL-300 study guide on Microsoft Learn: the skills measured, their weightings and any upcoming changes.
- The free Microsoft Learn learning paths for Power BI data analysts, with exercises.
- Power BI Desktop, which is free to download, for all hands-on practice.
- Microsoft's sample datasets and reports, for practising modelling on realistic data.
- The free practice assessment and the exam sandbox, which shows the question interface before exam day.
How to use the practice assessment well
Microsoft offers a free practice assessment on Microsoft Learn. Take it early as a diagnostic, not only at the end. Note every question you got wrong or guessed, find the matching skill in the official outline, practise that skill in Power BI Desktop, then retake the assessment a week or more later. Treat a high score from memorising its answers as a warning, not proof of readiness.
Common mistakes
- Watching course videos without building anything in Power BI Desktop.
- Learning DAX formulas by copying them, without understanding filter context.
- Skipping the manage and secure section because it feels administrative; it is part of the outline.
- Studying from an old outline after Microsoft has updated the skills measured.
- Leaving all review to the final week instead of revisiting weak areas each week.
Where Type to Study helps
Type to Study can turn your PL-300 notes, or a topic such as DAX filter context, into lessons you read and type, with key terms hidden for recall, flashcards on a spaced schedule and a timed practice exam with typed answers. It does not contain official Microsoft exam questions and does not run Power BI, so use it alongside Microsoft Learn, Power BI Desktop and the official practice assessment.
The day before the exam
- Review your weak-area list and flashcards; do not start new topics.
- Rebuild one small model and a few key measures from memory as a final check.
- Check the exam appointment, ID requirements and, for online exams, the system test.
- Sleep properly: memory and judgement both suffer after a late night.
Exam day tips
- Read each scenario for the requirement words: least effort, minimise size, must refresh daily.
- Flag long case studies and come back if time is short.
- Check Microsoft's current exam policies, timing and passing score on the official exam page.
Quick answers
How long does it take to prepare for PL-300?
It depends on your Power BI experience. Someone new to Power BI usually needs several weeks of regular practice; someone who builds reports at work may need less.
Do I need to know SQL for PL-300?
SQL is useful background, but the exam focuses on Power Query, data modelling, DAX and Power BI features.
Is PL-300 hard?
It is manageable with hands-on practice. Candidates most often struggle with data modelling and DAX, so give those the most time.
Does the certification expire?
Microsoft role-based certifications need periodic renewal through a free online assessment on Microsoft Learn. Check the current renewal rules on your certification's page.