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

The skills measured are split four ways: 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, as of the 20 April 2026 update to the objectives. Three quarters of the exam therefore sits in the build stages, and the last quarter is about what happens after you press Publish — workspaces, apps, gateways, endorsement, sensitivity labels, and row-level security.

Questions are scenario-driven rather than definitional. You are typically handed a requirement — a table too large to import, a date column that must serve both order date and ship date, a manager who may only see their own region — and asked which feature meets it. Knowing that row-level security filters in the model while a report filter only hides rows is the kind of distinction the exam turns on.

Microsoft prices associate and expert exams at US$165 as a typical figure, adjusted to local currency for the country or region in which the exam is proctored, and notes that prices are subject to change and that additional taxes may apply in some places. Scheduling runs through Pearson VUE, and Microsoft recommends registering with a personal account rather than a work or school account, because exam records tied to an organizational account are lost if you leave that organization.

The certification then expires after 12 months, but renewal is free: you pass an online renewal assessment on Microsoft Learn rather than repaying for the exam. Practice assessments and the official study guide are also free, so the $165 is genuinely the whole required outlay unless you choose to buy training.

You have 100 minutes to complete the assessment. It is proctored, and Microsoft notes it may include interactive components, so expect more than plain multiple choice. Microsoft does not publish a question count for PL-300 — any specific number you see quoted online is an estimate rather than an official figure — so plan your pacing around the clock rather than around an assumed item count.

The passing mark is a scaled score of 700 or greater, which is not a percentage of questions answered correctly. The exam is offered in ten languages including English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Chinese (Traditional), and Italian, and if it is not available in your preferred language you can request an additional 30 minutes. If you fail, you can retake it 24 hours after the first attempt; later retakes have longer waits.

PL-300 gives you 100 minutes, requires a scaled score of 700 or greater to pass, costs a typical US$165, and expires after 12 months unless you take the free renewal assessment on Microsoft Learn. One number you will see everywhere is not on that list: Microsoft does not publish how many questions are on the exam, so every "40 to 60 questions" figure in the search results is a third-party estimate.

The facts Microsoft publishes

The 700 is a scaled score, not a percentage, so it cannot be converted into a number of questions you are allowed to miss. Combined with the unpublished item count, that means pacing has to come from the clock and the progress indicator rather than from minutes-per-question arithmetic.

What is on the exam

Those weights are the ones in effect from 20 April 2026. Read them before you plan, because they contain two warnings.

First, modelling is worth as much as report building. You can produce good-looking Power BI reports for years without ever needing a proper star schema, a marked date table, or USERELATIONSHIP — and a quarter of this exam is exactly that material. If your day job is dashboards, modelling is where your gap is.

Second, the fourth area is real. 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 difficult, but almost none of it is picked up by accident if you have never administered a tenant.

Microsoft also notes that most questions cover generally available features and that Preview features may appear when they are commonly used. Copilot-driven report authoring is in the published objectives, so treat it as in scope.

The two skills that carry the exam

Microsoft states directly that you should be proficient at using Power Query and Data Analysis Expressions. Nearly every scenario question resolves to one of the two.

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

For DAX, the entire 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 memory and evaluation differences between a measure and a calculated column.

Storage modes, the other reliable question source

A four-week study plan

Week 1 — audit yourself against the official study guide. 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 something you can either demonstrate in Power BI Desktop or cannot. That self-audit beats any question dump for deciding where your time goes.

Week 2 — build one real model. Import a few tables, shape them in Power Query, wire a star schema with a marked date table, and write the measures: a base sum, a year-to-date, a prior-year comparison using an inactive relationship, a safe ratio with DIVIDE, a distinct customer count. Anything you have built once, you will recognize in a scenario question.

Week 3 — close the administration gap deliberately. Publish that model to a workspace. Create a row-level security 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. Open Lineage view. An hour of this beats a chapter of reading about it.

Week 4 — the free practice assessment and the exam sandbox. The sandbox exists so the interface and the interactive question types are not new to you when the clock is running. Use it at least once before the day.

Booking and renewal

Scheduling runs through Pearson VUE, at a test centre or online. Register with a personal Microsoft account rather than a work or school account — Microsoft warns that exam 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.

If you fail, you can retake 24 hours after the first attempt; later retakes have longer waits, and your score report breaks performance down by skill area so you know where to concentrate. If you pass, put a calendar reminder at ten months. The credential expires after 12 months, and renewal is a free online assessment on Microsoft Learn — letting it lapse converts something free into another US$165 exam.