PL-300 Study Guide 2026 and How to Pass the Power BI Exam
By the QlearnAI team · Updated
To pass PL-300 (Microsoft Power BI Data Analyst), study four skill areas: preparing the data, modeling it and visualizing it (25–30% each), plus managing and securing Power BI (15–20%). Most people who already use Excel or a little Power BI can prepare in four to six weeks by building reports in Power BI Desktop and checking readiness with Microsoft's free practice assessment. You need a scaled score of 700 out of 1,000.
What does the PL-300 exam cover?
These are the skills measured as of 20 April 2026, from the PL-300 study guide on Microsoft Learn:
| Skill area | Weight |
|---|---|
| Prepare the data | 25–30% |
| Model the data | 25–30% |
| Visualize and analyze the data | 25–30% |
| Manage and secure Power BI | 15–20% |
Prepare the data
- Getting data and choosing a storage mode: Import, DirectQuery or Direct Lake
- Parameters and data profiling
- Cleaning and shaping in Power Query: pivot, unpivot, merge and append
- Reference versus duplicate queries
Model the data
- Fact and dimension tables, and role-playing dimensions
- Relationship cardinality and cross-filter direction
- A date table
- DAX: CALCULATE, time intelligence and semi-additive measures
- Calculation groups and visual calculations
- Performance Analyzer and DAX query view
Visualize and analyze the data
- Report design, bookmarks, drillthrough and synced slicers
- Accessibility
- Copilot in Power BI: the narrative visual, creating a new report page and summarizing a model
- Paginated reports
Manage and secure Power BI
- Workspaces and apps
- Gateways and scheduled refresh
- Row-level security (RLS)
- Sensitivity labels
Check the "skills measured as of" date on the study guide page before you start. Microsoft updates the list.
Who is PL-300 for?
PL-300 is a role-based associate exam for data analysts who turn data into reports and dashboards in Power BI. It suits analysts, finance and operations people who report on data, and anyone moving into a BI role. You don't need to be a programmer, but you'll need to get comfortable with DAX.
It's also a common first step toward Microsoft Fabric. Many people take PL-300, then DP-600 (Fabric Analytics Engineer); see DP-600 vs DP-700 for how the Fabric exams differ.
PL-300 study plan: 5 weeks
This plan assumes 6–8 hours a week and Power BI Desktop installed. Use one dataset all the way through so each week builds on the last.
| Week | Focus | What to do |
|---|---|---|
| 1 | Baseline and Power Query | Take the free practice assessment cold. Load a messy dataset and clean it: profile the columns, unpivot, merge and append. Try both a reference and a duplicate query and see what changes. |
| 2 | Modeling | Turn your data into a star schema with fact and dimension tables. Add a date table. Set relationships and experiment with cardinality and cross-filter direction. Add a role-playing date dimension. |
| 3 | DAX | Write measures with CALCULATE, then time intelligence (year to date, prior year), then a semi-additive measure like a closing balance. Try a calculation group and a visual calculation. Use Performance Analyzer and DAX query view to look at what your measures do. |
| 4 | Reports and Copilot | Build a report with bookmarks, drillthrough and synced slicers. Check accessibility settings. If you have access, try Copilot's narrative visual and report page creation. Look at what a paginated report is for. |
| 5 | Manage, secure and review | Publish to a workspace, create an app, set up RLS and test it, and read up on gateways, scheduled refresh and sensitivity labels. Retake the practice assessment and spend the rest of the week on the areas you missed. |
Space your practice out and test yourself rather than rereading. Our how to learn guide explains why practice testing and spaced practice are the two most useful study techniques. If you want a practice course built from the skills list, paste it into QlearnAI and it creates lessons and quizzes that explain each answer.
Topics that trip people up
These come from the skills list. They're areas worth extra practice, not claims about real exam questions.
- Storage modes. Import, DirectQuery and Direct Lake each have trade-offs in freshness, performance and where the data lives. Learn when each one fits.
- Reference vs duplicate queries. They look similar in Power Query but behave differently when the source query changes. Test it yourself.
- Cardinality and cross-filter direction. Get comfortable with one-to-many and many-to-many, and with when bidirectional filtering helps or causes problems.
- Role-playing dimensions. One date table related to several date columns needs inactive relationships and DAX to switch them on. Build one.
- CALCULATE and filter context. Most DAX confusion starts here. Write measures until you can predict the result before you see it.
- Semi-additive measures. Balances and inventory don't add up over time the way sales do. Practice a closing-balance measure.
- RLS. Know how to define roles and test them, and how security applies once a report is published.
- Manage and secure. It's the smallest area at 15–20%, so people leave it for last. Workspaces, apps, gateways and refresh still decide a real share of your score.
Where can you get a free PL-300 practice exam?
- Microsoft's free practice assessment: aka.ms/PL300-PA. As of 2026 the new practice assessment experience is on AI Skills Navigator, and you sign in to use it. The legacy version on Microsoft Learn is no longer updated.
- Exam sandbox: see the question types and interface at aka.ms/examdemo.
- Microsoft Learn: the learning paths linked from the PL-300 study guide are free. Free Microsoft certification courses explains how to find them.
How the PL-300 exam works
- Passing score: 700 on a scale of 1–1,000, a scaled score rather than 70% of questions (scoring).
- Length: most exams have 40–60 questions. Associate exams run 100 minutes, or 120 if they may include labs. Check the PL-300 exam page for the current format (exam duration).
- Microsoft Learn during the exam: as a role-based exam, PL-300 lets you open Microsoft Learn in a split screen. You get no extra time, so use it to confirm a detail, not to look up every question.
- Guessing: there's no penalty, so answer every question.
- Breaks: allowed, but the clock keeps running and you can't return to questions from before the break.
More exam-day tactics are in how to pass a Microsoft certification exam.
How much does PL-300 cost?
The price depends on the country where you take the exam. In the US, associate exams like PL-300 are typically $165, as widely reported. Check the PL-300 exam page for your country, and tax may be added. Failed exams and missed appointments aren't refunded.
Students in most countries, except India and China, can get academic pricing by setting their Learn profile to Student and verifying before they pay (student discounts).
Is there a PL-300 voucher or discount right now?
Yes, a 50% one. Microsoft Data Days 2026 runs on the Fabric Community from 2 November to 15 December 2026 and includes 50% vouchers for PL-300. To claim one:
- Create a free Fabric Community account.
- Register on the Data Days 2026 page and request the voucher under "Get Certified".
- Watch your Fabric Community inbox for the code, which arrives as a private message.
- Book and take PL-300 by 31 January 2027.
It's one voucher per person and supply is limited. If you miss it, our guide to getting a free Microsoft certification explains when offers like this usually appear.
If you fail, the first retake is after 24 hours, then 14 days between later attempts, up to five attempts in 12 months, and you pay for each one (retake policy). PL-300 expires every 12 months, and renewal is a free online assessment on Microsoft Learn.
Should I use PL-300 dumps?
No. Microsoft lists brain dumps, sites that sell real exam questions, as fraudulent activity. Using them can get your score and certification revoked and you banned from future exams, and Microsoft uses statistical analysis to detect it (exam security policy).
PL-300 is a skills exam for a job you'll actually do. On the job you'll build reports and explain your measures, and memorized answers won't help there, and the skills list changes often enough that old dumps go stale anyway. The free practice assessment and a few weekends in Power BI Desktop are a better use of your time.
Frequently asked questions
How long does it take to study for PL-300?
Most people with some Excel or Power BI experience need four to six weeks at 6–8 hours a week. Complete beginners may want a couple of extra weeks for DAX. Take the free practice assessment at the start and end to measure progress.
Is PL-300 hard?
It's an associate-level exam with four broad areas, and DAX is the part most people find hardest. If you build real reports while you study, the rest becomes familiar quickly. Hands-on practice matters more than reading.
What is the passing score for PL-300?
You need 700 on a scale of 1–1,000. It's a scaled score, not 70% of questions. There's no penalty for guessing.
Can I use Microsoft Learn during the PL-300 exam?
Yes. PL-300 is a role-based exam, so you can open Microsoft Learn in a split screen. There's no extra time, and you can only use learn.microsoft.com.
How much does the PL-300 exam cost?
The price depends on your country. In the US it's typically $165, as widely reported, plus any tax. Right now Microsoft Data Days 2026 offers a 50% voucher for PL-300 that must be used by 31 January 2027.
Is there a free PL-300 practice exam?
Yes. Microsoft's official practice assessment is free at aka.ms/PL300-PA, now on AI Skills Navigator. You can also try the exam interface at aka.ms/examdemo.
Does PL-300 expire?
Yes. It expires every 12 months. You renew for free by passing a short, unproctored, open-book assessment on Microsoft Learn in the six months before it expires.
Should I take PL-300 before DP-600?
It's not required, but it's a common order. PL-300 builds the modeling and DAX skills that DP-600 expands on in Microsoft Fabric. When you're ready, our free DP-600 exam prep course picks up from there.