PL-300 Exam Guide 2026: Skills Measured, Format, Passing Score and a Study Plan
Gulab Chand Tejwani
PMP · PL-300 · Microsoft Certified Trainer
· 14 min read
PL-300 is the exam you pass to earn the Microsoft Certified: Power BI Data Analyst Associate certification. It tests four skill areas: preparing the data (25 to 30%), modelling the data (25 to 30%), visualising and analysing the data (25 to 30%), and managing and securing Power BI (15 to 20%). You get 100 minutes, you need a score of 700 or more to pass, and the certification is valid for 12 months, after which you renew it for free with an online assessment on Microsoft Learn.
I checked every fact in this guide against Microsoft Learn on 18 October 2026. The current skills outline is the one Microsoft labels "skills measured as of April 20, 2026". Microsoft changes the outline from time to time, so open the official PL-300 study guide before you book and compare it with what I've written here.
I'm Gulab Chand Tejwani. I hold the PL-300 certification myself, I'm a Microsoft Certified Trainer, and I teach Power BI at TechNet Consultancy in Anand. What follows is what I tell my own batches in the first session.
What is the PL-300 exam?
PL-300 is called "Microsoft Power BI Data Analyst". Pass it and Microsoft awards you the Power BI Data Analyst Associate certification, which is an intermediate-level, role-based credential. There's only one exam for this certification, so you don't need a fundamentals exam first, and Microsoft lists no formal prerequisites.
The audience Microsoft describes is someone who works with business stakeholders to understand what they need, gets data from engineers or source systems, and turns it into reports people can use for self-service analysis. The study guide says you should be proficient in Power Query and DAX. In my experience that one line is the best summary of the exam. People who are comfortable with visuals but weak in Power Query and DAX tend to struggle.
What skills does PL-300 measure in 2026?
These are the four functional groups and their weights from the outline dated 20 April 2026. Microsoft publishes ranges rather than exact percentages, which is why every area shows a lower and an upper bound.
- Prepare the data (25 to 30%). Connecting to sources or a shared semantic model, credentials and privacy levels, choosing between Import, DirectQuery and Direct Lake, parameters, profiling and cleaning data, fixing import errors, data types, pivot and unpivot, merge and append, reference versus duplicate queries, and creating fact and dimension tables and keys.
- Model the data (25 to 30%). Table and column properties, role-playing dimensions, relationship cardinality and cross-filter direction, a common date table, calculated columns and tables, and DAX: single aggregation measures, CALCULATE, time intelligence, basic statistics, semi-additive measures, quick measures and calculation groups. It also covers performance work with Performance Analyzer and DAX query view.
- Visualize and analyze the data (25 to 30%). Choosing and formatting visuals, themes, conditional formatting, slicing and filtering, paginated report decisions, visual calculations, Copilot features for report pages and narratives, bookmarks, tooltips, drillthrough, sync slicers, mobile layouts, accessibility, and analytics features such as grouping, binning, clustering, forecasting, reference lines and anomaly detection.
- Manage and secure Power BI (15 to 20%). Workspaces and apps, publishing, distribution methods, subscriptions and alerts, endorsement (promote and certify), when a gateway is needed, scheduled refresh, workspace roles, item-level access, row-level security roles and group membership, and sensitivity labels.
Two things stand out in the 2026 outline. Copilot now appears in several places, so expect questions about what it can do in a report and in summarising a semantic model. And "calculation groups" and "visual calculations" are named explicitly in the DAX and report sections. If your study material is a couple of years old, it may skip both.
Which skill areas do candidates find hardest?
The weights tell you where the marks are. They don't tell you where people lose them. This is what I see in practice when students sit practice tests at the end of a batch.
| Skill area | Common weak spot | How to fix it |
|---|---|---|
| Prepare the data | Reference vs duplicate queries, privacy levels | Build one staging query and reference it for every table |
| Model the data | Filter context in CALCULATE, role-playing dates | Write ten measures from real business questions |
| Visualize and analyze | Newer features: visual calculations, Copilot | Read the Microsoft Learn pages for each named feature |
| Manage and secure | Workspace roles, RLS testing, gateways | Publish a report and test every role with View as |
Manage and secure surprises people most. It's the smallest area, but candidates who learned only in Power BI Desktop have usually never assigned a workspace role or configured a gateway, and those questions are pure recall of how the service behaves.
How long is the exam and what is the passing score?
Microsoft's certification page gives these details:
- Duration: 100 minutes to complete the exam. The exam is proctored and may include interactive components.
- Passing score: 700 or greater. Microsoft scores on a scale and does not publish a fixed number of questions or a simple percentage, so don't try to work backwards from "700 out of 1000".
- Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Chinese (Traditional) and Italian. If the exam isn't offered in your preferred language, the study guide says you can request an extra 30 minutes.
- Booking: You schedule through Pearson VUE, either at a test centre or online proctored. Microsoft recommends registering with a personal Microsoft account, not a work or school account, because records tied to an organisational account can be lost if you leave.
- Price: Microsoft says the price depends on the country where the exam is proctored. Check the current fee for India on the booking page rather than trusting a figure in a blog post (including this one).
- Retakes: If you fail, you can retake after 24 hours. Later retakes have longer waiting periods, which Microsoft lists in its exam retake policy.
Microsoft also runs an exam sandbox so you can try the question formats before the real thing. Use it. I've seen well-prepared people lose time in the first ten minutes because they didn't know how a drag-and-drop or case-study item behaves.
How do you renew PL-300?
The certification lasts 12 months. Within the renewal window (Microsoft opens it before the expiry date), you take a free, unproctored online renewal assessment on Microsoft Learn. You don't pay again and you don't sit the full exam. The renewal assessment focuses on recent changes to the product, which is the point: Power BI changes every month. Microsoft's renewal page explains the window and what happens if you miss it.
My advice: link your certification profile to your Microsoft Learn account the day you pass. Renewal reminders go there, and that's also where you share the credential link with employers.
Is PL-300 hard for beginners?
It's an associate-level exam, not an entry-level one. Beginners do pass it, but almost never by reading alone. The questions are written as small work scenarios: a model with a problem, a requirement from a manager, a report that's slow. You have to know what the product does when you click things, and that only comes from building.
The people I see struggle usually fall into one of three groups. Some learned Power BI only through visuals and never built a proper model. Some know DAX syntax but can't explain filter context, so CALCULATE questions trip them. And some have never used the Power BI service, so workspace roles, apps and row-level security feel abstract.
If you can build a star schema from messy files, write measures with CALCULATE and time intelligence, publish to a workspace, set up scheduled refresh and test a row-level security role, you're in good shape.
What kind of questions does PL-300 ask?
Microsoft doesn't publish real questions, and you should stay away from anyone selling "dumps". They break Microsoft's exam rules and they teach you nothing. But the style is predictable from the outline and Microsoft's free practice assessment. Here's the kind of scenario I write for my own batches:
Your report has a Sales table with OrderDate and ShipDate, both related to a Date table. The OrderDate relationship is active. A manager wants a visual showing sales by ship month. You need to minimise changes to the model. What should you do?
The answer is a measure that wraps the sales calculation in CALCULATE with USERELATIONSHIP on the ShipDate relationship. Duplicating the Date table would also work, but it changes the model more, and the requirement said to minimise changes. That phrase is doing the work. Most PL-300 scenarios are like this: two answers would technically work, and one line in the requirement picks the winner.
Other formats you'll meet include drag-and-drop ordering (put the Power Query steps in the right sequence), hot-area questions on a screenshot of a settings pane, and case studies where several questions share one long business scenario.
A six-week PL-300 study plan
This plan assumes about 6 to 8 hours a week and that you already use Excel comfortably. Stretch it if you're starting from zero.
Week 1: Power Query. Connect to Excel, CSV and a folder of files. Practise data types, splitting columns, unpivoting, merge versus append, and the data profiling tools (column quality, distribution, profile). Build one clean fact table and two dimension tables. Leave DAX for later; this week is only about clean data.
Week 2: Data modelling. Learn the star schema, relationship cardinality, single versus both-direction filtering, and why a dedicated date table matters. Build a role-playing date dimension (order date and ship date) and handle the inactive relationship.
Week 3: DAX foundations. Measures versus calculated columns, SUM versus SUMX, row context versus filter context, and CALCULATE with filters, REMOVEFILTERS and ALL. Write ten measures from a real business question each.
Week 4: More DAX and performance. Time intelligence (year to date, same period last year, moving averages), semi-additive measures such as closing balance, calculation groups, and visual calculations. Run Performance Analyzer on your report and fix the slowest visual.
Week 5: Reports and the service. Bookmarks, drillthrough, custom tooltips, sync slicers, mobile layout and accessibility settings. Then publish: workspace roles, an app, a subscription, a data alert, scheduled refresh, and a row-level security role tested with "View as".
Week 6: Practice and gaps. Take Microsoft's free PL-300 practice assessment, read every explanation (including for the ones you got right), and go back to the outline line by line. Tick only what you've actually done in Power BI Desktop or the service.
What study resources should you use?
Start with what Microsoft gives away: the study guide, the self-paced learning paths on Microsoft Learn, the practice assessment and the exam sandbox. They're free and they match the current outline.
| Option | Good for | Watch out for |
|---|---|---|
| Microsoft Learn paths and practice assessment | Free, always matches the current outline | No one reviews your models or DAX |
| Self-paced course with labs | Structure and datasets at your own speed | Easy to stall without a timetable |
| Instructor-led training | Feedback on your work, fixed schedule | Costs more; check the trainer's credentials |
| Exam dumps | Nothing | Breaks Microsoft's rules and teaches no skill |
Then add hands-on work with someone checking it. This is where a course earns its fee. In our instructor-led Power BI training in Anand or live online we map the 30 teaching hours to the four PL-300 areas and review your models and measures in class. If you'd rather study alone, the self-paced Power BI online course has text lessons, labs, datasets and PL-300 study guidance, and you can read a free preview lesson first. Neither option includes the Microsoft exam fee or a voucher, and no course can guarantee a pass.
For practice ideas, my post on Power BI projects for beginners has six projects that cover most of the Prepare and Model sections. If you're still deciding how to learn, read how to choose a Power BI course.
Exam-day tips from a PL-300 holder
- Read the last line of each question first. It tells you what's actually being asked, and many scenario questions include details you don't need.
- Watch for "minimise effort" or "minimise model size" in the requirement. Two answers might both work, and that phrase decides which one Microsoft wants.
- Case studies come with their own time pressure. Skim the requirements tab before reading the whole scenario.
- Mark and move on. Don't spend eight minutes on one DAX question.
- For online proctoring, clear your desk completely and run the system check a day early. Your webcam, internet and room all get checked.
FAQ
How many questions are on the PL-300 exam?
Microsoft does not publish a fixed number. The count varies between exam forms, and some questions are grouped into case studies. Plan your time around the 100-minute limit, not a question count.
What is the PL-300 passing score?
You need 700 or more on Microsoft's scaled score. Because it's scaled, 700 is not the same as 70% of questions correct.
Does the PL-300 certification expire?
Yes. It's valid for 12 months. You renew it for free by passing an online renewal assessment on Microsoft Learn during the renewal window.
Can I take PL-300 online from India?
Yes. You can book an online proctored exam through Pearson VUE or sit it at a test centre. Check the current price for India when you book, because Microsoft prices exams by country.
How long does it take to prepare for PL-300?
If you already use Excel well, six to eight weeks of regular hands-on practice is realistic. Complete beginners often need longer. The real test is whether you can do every line in the skills outline in Power BI, not how many hours you've studied.