Microsoft Certified: Power BI Data Analyst Associate (Exam PL-300) Study Guide

100 minutes. A scaled passing score of 700. A US$165 typical fee for an associate exam, priced by the country or region where you are proctored, with tax possibly on top. A 12-month certification life, renewed free by an online assessment on Microsoft Learn rather than by repaying for the exam. And a 24-hour wait before your first retake if it goes badly.

One number is missing on purpose: Microsoft does not publish how many questions are on PL-300. Every article that tells you it is 40 to 60 is guessing. That matters practically — you cannot budget minutes per question against a number nobody has confirmed — so pace yourself by the clock and by how much of the exam remains on the progress indicator instead.

The 700 is also not a percentage. It is a scaled score across a fixed range, so you cannot convert it to a number of questions you are allowed to miss.

Four skill areas, weighted as of the 20 April 2026 objectives update: Prepare the data at 25-30 percent, Model the data at 25-30 percent, Visualize and analyze the data at 25-30 percent, and Manage and secure Power BI at 15-20 percent.

Read those weights carefully before you plan. The three build areas are equal, which means modelling is worth as much as report building — and modelling is where most self-taught Power BI users are weakest, because you can produce good-looking reports for years without ever needing a proper star schema, a marked date table, or USERELATIONSHIP. If your day job is dashboards, this is where your gap is.

The fourth area is the one people skip and then fail on. Workspace roles, apps, build permission, gateways, endorsement, sensitivity labels, row-level security, and refresh limits are up to a fifth of the exam. None of it is hard, but almost none of it is learned by accident if you have never administered a tenant.

Microsoft also states that most questions cover generally available features, and that Preview features may appear when they are commonly used. Copilot-driven report authoring now sits in the published objectives, so treat it as in scope rather than as a novelty.

Microsoft states plainly that you should be proficient at using Power Query and Data Analysis Expressions. Those two tools cut across every skill area, and almost every scenario question resolves to one of them.

For Power Query, the concept that earns the most marks is query folding — the engine translating your steps into a native source query. Know that removing columns and filtering rows early preserves folding while some transformations break it, and know that a greyed-out View Native Query option is how you spot the break. Around that, be fluent in merge versus append, pivot versus unpivot, reference versus duplicate, parameters, privacy levels, and the RangeStart and RangeEnd parameters that incremental refresh requires by name.

For DAX, the whole subject is filter context. A measure is recomputed for every cell it appears in, which is why a ratio's grand total is not the sum of the rows above it, and CALCULATE is the function that modifies that context. Build outward from there: time intelligence over a marked date table, USERELATIONSHIP for role-playing dimensions, REMOVEFILTERS and KEEPFILTERS, DIVIDE for safe division, and the difference between a measure and a calculated column in both memory and evaluation time.

Work from the official study guide outward. It is free, it lists every bullet Microsoft assesses, and it carries a change log showing what moved at the last update. Treat each bullet as a checkbox you can either demonstrate in Power BI Desktop or cannot — that self-audit is more useful than any question dump.

Build one real model rather than reading about many. Import a few tables, shape them in Power Query, wire a proper star schema with a marked date table, and then write the measures: a base sum, a year-to-date, a prior-year comparison with a role-playing date relationship, a safe ratio, a distinct customer count. Anything you can build once you can recognize in a scenario question.

Then close the administration gap deliberately, because it will not close itself. Publish that model to a workspace. Create a role with a DAX filter and assign a member. Publish an app and look at what a Viewer sees. Configure a refresh and see what it demands. Look at Lineage view. An hour of this is worth more than a chapter of reading about it.

Use the free practice assessment and the exam sandbox before the day. The sandbox exists so the interface and the interactive question types are not new to you when the clock is running.

The exam is proctored and may include interactive components, so expect at least some items that ask you to work in an interface rather than pick a letter. Scheduling runs through Pearson VUE, and you can sit it at a test centre or online.

Register with a personal Microsoft account rather than a work or school account. Microsoft warns that records tied to an organizational account are lost and unrecoverable if you leave that organization, and this is the single most avoidable long-term mistake candidates make.

The exam is offered in ten languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Chinese (Traditional), and Italian. If it is not available in your preferred language you can request an additional 30 minutes. Note also that localized versions are updated roughly eight weeks after the English version, so soon after an objectives change the two can differ slightly.

With 100 minutes and no published item count, keep moving. Flag anything that needs a second look rather than stalling, and leave nothing unanswered — there is no published penalty for a wrong answer, so a considered guess strictly beats a blank.

You need 700 or greater to pass, and the score report breaks performance down by skill area, which tells you where to concentrate if you have to sit it again. A first retake is available 24 hours after the first attempt; the wait for subsequent retakes is longer.

If you passed, put a reminder in your calendar now. The credential is valid for 12 months and Microsoft associate certifications expire unless renewed, but renewal is a free online assessment on Microsoft Learn rather than a repeat of the paid exam. The renewal window opens well before expiry, and letting it lapse means paying US$165 again for something that would have cost nothing.

Keep an eye on the study guide's change log too. Microsoft updates objectives periodically — the current set took effect on 20 April 2026 — and the renewal assessment tracks the current version, not the one you originally sat.