Exam PL-300 is the single exam behind the Microsoft Certified: Power BI Data Analyst Associate credential. For analysts who already build reports, the open question is rarely “can I use Power BI?” It is “which parts of the tool does Microsoft actually test, and how is the score produced?”
This guide answers both from Microsoft’s own published documents: the skills outline that took effect on April 20, 2026, the exam detail page, the scoring page, and the retake policy. Where a figure can change by region or over time, that is noted. Nothing here comes from leaked questions or vendor claims.
Who the exam is written for
Microsoft’s audience profile describes a candidate who delivers “actionable insights by working with available data and applying domain expertise,” provides business value “through easy-to-comprehend data visualizations,” and enables others “to perform self-service analytics.” The analyst works with business stakeholders on requirements and with analytics engineers and data engineers to acquire data.
One sentence in that profile matters more than the rest: “You should be proficient at using Power Query and Data Analysis Expressions (DAX).” Microsoft lists the exam at the Intermediate level. If you are comfortable in pandas or SQL but have only clicked through the Power BI interface, DAX is where the extra study time goes.
The exam at a glance
| Item | What Microsoft publishes |
| Fee | US$165 list price for associate exams; priced by the country or region where the exam is proctored, and local taxes may apply |
| Time | 100 minutes |
| Questions | Microsoft says most of its certification exams contain 40 to 60 questions; it does not publish a fixed count for PL-300 |
| Score | Reported on a scale of 1 to 1,000; 700 or greater passes |
| Delivery | Scheduled through Pearson VUE; proctored; may include interactive components |
| Languages | English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Chinese (Traditional), Italian |
| Validity | Expires annually; renewed free through an online assessment on Microsoft Learn |
Sources: Microsoft’s PL-300 exam page and certification FAQ on Microsoft Learn.
The four skill areas and their weights
The official study guide lists four areas, with weights measured as of April 20, 2026.
| Skill area | Weight | What the outline covers |
| Prepare the data | 25–30% | Connecting to sources or a shared semantic model; choosing between DirectLake, DirectQuery, and Import; profiling and cleaning; transforming and loading with Power Query, including merges, appends, pivots, and fact and dimension tables |
| Model the data | 25–30% | Relationship cardinality and cross-filter direction; a common date table; role-playing dimensions; DAX measures with CALCULATE, time intelligence, semi-additive measures, and calculation groups; performance work with Performance Analyzer and DAX query view |
| Visualize and analyze the data | 25–30% | Choosing and formatting visuals; Copilot tasks such as narrative visuals and new report pages; visual calculations in DAX; bookmarks, drillthrough, mobile layouts, and accessibility; grouping, binning, clustering, forecasting, and anomaly detection |
| Manage and secure Power BI | 15–20% | Workspaces, apps, and distribution; gateways and scheduled refresh; subscriptions and data alerts; promoting or certifying content; row-level security, item-level access, and sensitivity labels |
Microsoft’s change log compares this outline with the previous version. The weights did not move, and only three sub-areas are marked “Minor” change: Get or connect to data, Enhance reports for usability and storytelling, and Create and manage workspaces and assets. Study material written for the earlier outline is therefore not obsolete, but check those three sections against the current bullet list before relying on it.
Two notes in the same document affect how you prepare. Most questions cover features that are generally available, but the exam “may contain questions on Preview features if those features are commonly used.” And the bullets under each skill are illustrations of how the skill is assessed, not an exhaustive list, so “related topics may be covered.”
What the weights mean for your time
Between 50% and 60% of the exam sits in Prepare and Model. Both are exercised almost entirely in Power Query and DAX. That is the arithmetic behind Microsoft’s proficiency sentence, and it is why candidates who are strong at visual design still fail: a polished report page is worth at most a third of the score.
Manage and secure is the smallest area, but it is the one most likely to be untouched by day-to-day work. If your routine ends at the Publish button, you may never have assigned workspace roles, configured a gateway, scheduled a refresh, applied a sensitivity label, or tested row-level security with a real group membership. Those are specific, learnable tasks, and at 15% to 20% they can decide a borderline result.
Four scoring facts that change how you sit the exam
- 700 is a scaled score, not 70%. Microsoft’s scoring page states that the passing score “may not equal 70% of the points.” It is set from the knowledge required to demonstrate competence and the difficulty of the questions. A practice score of 72% is not evidence that you are safely over the line.
- There is no penalty for guessing. An incorrect answer simply earns no point. Never leave an item blank.
- Some questions are unscored. Microsoft includes pretest items to gather data for future exams. An unusually hard question may not count, so do not let one derail your pacing.
- The score report bars cannot be added up. Each section has a different number of questions, so the per-area bars show relative strength, not a reconstruction of the total.
Two format notes complete the picture. Case studies present a scenario that you can reread while several questions are asked against it. If an exam contains labs, each lab has 7 to 15 tasks, and Microsoft does not publish which exams include them because labs can be withdrawn during outages. The practical consequence: rehearse tasks in Power BI Desktop and the Power BI service, not only on multiple-choice questions.
A six-week plan weighted like the exam
The schedule below allocates time in roughly the proportions the outline uses. Adjust it to your starting point; it is an example, not a Microsoft program.
Weeks 1 and 2: Prepare the data. Work through the Power Query bullets in order. Connect to at least three different source types, change credentials and privacy levels, and build a small star schema from a flat export: a fact table, two dimension tables, and the keys that join them. Deliberately introduce a bad data type and a null, then fix both.
Weeks 3 and 4: Model the data. Build the date table yourself rather than relying on auto date/time. Write the same measure three ways: a plain aggregation, a CALCULATE with a filter, and a time-intelligence version. Add a semi-additive measure such as a closing balance. Open Performance Analyzer and DAX query view on a slow visual and explain to yourself why it is slow.
Week 5: Visualize, then manage and secure. Spend the first half on report mechanics the outline names: bookmarks, drillthrough with buttons, sync slicers, a mobile layout, and an accessibility pass. Spend the second half in the service: create a workspace, publish, build an app, schedule a refresh, assign roles, and implement row-level security with a group rather than an individual.
Week 6: Measure and fill gaps. Start with Microsoft’s own Practice Assessment on AI Skills Navigator, which the study guide now recommends over the legacy Learn version. Then widen the sample with a free PL-300 practice test of 160 exam-style questions with explanations and no signup, and read every explanation for the items you missed or guessed. Score yourself by skill area, not by total, because that is how the real report will show you your weaknesses.
Two days before the appointment, condense your notes to a single page: the four areas and their weights, the scoring rules above, the retake clock, and the DAX functions you still confuse. If PL-300 is one step in a longer plan, it helps to see it beside the Azure, AWS, CompTIA, and Cisco exams that often follow it. Every Exam Prep’s IT certification practice test hub lists those exams with free question banks for each, so you can compare formats and fees before committing to the next one.
Retakes, renewal, and the account mistake to avoid
Microsoft’s retake policy allows a second attempt 24 hours after the first. Every attempt after that requires a 14-day wait, and you may not take the same exam more than five times in a 12-month period counted from the first attempt. After a fifth failure, the next attempt opens 12 months from that first date. Microsoft does not refund a failed exam or a missed appointment.
Renewal is lighter. Associate certifications expire annually, and you can take the renewal assessment at any time during a six-month eligibility window on Microsoft Learn. It is free, shorter than the original exam, and open book, and you can retake it as many times as needed before the certification expires. Passing extends the certification one year from the expiration date.
One administrative point costs people their records every year. Microsoft strongly recommends registering with a personal Microsoft account. If you register with a work or school account and later leave that organization, your exam records are lost and cannot be recovered.
Start with the official pages
Before buying any course, read the three Microsoft pages linked above, take the exam sandbox tour, and run the official Practice Assessment once cold. That establishes which of the four areas needs the most of your six weeks. Everything else in this guide is a way of spending that time in the same proportions the exam will.