Why this level comes first
PL-300 is the exam for the Microsoft Certified: Power BI Data Analyst Associate certification. You've used Excel and some Power BI already. What you need now is a clear picture of what the exam measures and how it asks questions. That way, every hour you study lands on something that earns marks.
Two things first:
- This course is independent of Microsoft. Microsoft hasn't endorsed it, and it isn't official training.
- Nobody can promise you a pass, including this course. The course gives you structure, practice and explanations. The exam itself gives you the result.
Where the official material lives (and why we point to it rather than copy it)
Microsoft writes the Study guide for Exam PL-300. It's free on Microsoft Learn (aka.ms/pl300-StudyGuide). This course follows its "Skills measured as of April 20, 2026" list bullet by bullet, but doesn't reproduce it. There are two reasons:
- It's Microsoft's document. The original is the authority.
- It changes. Microsoft updates exams from time to time. When a change is coming, the guide can show two versions of the skills list, plus a change log. The April 2026 update made minor changes to "Get or connect to data", "Enhance reports for usability and storytelling" and "Create and manage workspaces and assets". English is updated first. Other languages follow about eight weeks later. A copied list goes out of date without anyone noticing.
Bookmark these three free resources from the same page:
| Resource | What it's for |
|---|---|
| Study guide | The list of skills measured. This is your syllabus. |
| Practice Assessment | Sample questions showing the style, wording and difficulty. They are not the real questions. |
Exam sandbox (aka.ms/examdemo) |
A demo of the exam interface: navigation, mark for review, the different question types. |
Habit worth forming: before you book, check the "Skills measured as of" date on the study guide. If it lists two versions, study the one that applies on your exam date.
The exam in numbers
Duration : 100 minutes for the questions (plan about 120 minutes in the seat,
which includes instructions, the agreement and comments)
Pass mark : 700 or more, on a scale of 1 to 1,000. This is a SCALED score,
so it doesn't have to equal 70% of the points
Guessing : no penalty. A wrong answer just earns 0 for that part
Partial credit : multi-part questions usually give 1 point per correct part
Unscored items : some questions may not count, and you can't tell which ones
Language : if PL-300 isn't offered in your preferred language,
you can request an extra 30 minutes
Renewal : the certification expires after 12 months; renewing is a
free online assessment on Microsoft Learn
The four sections and their weightings, word for word from the guide:
| Section | 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% |
Turn the weights into a study budget
Most Microsoft exams have between 40 and 60 questions, and the exact number varies. Here's a quick sum to see what the weights mean for a 50-question exam:
weights = { # (low, high) share of the exam
"Prepare the data": (0.25, 0.30),
"Model the data": (0.25, 0.30),
"Visualize and analyze": (0.25, 0.30),
"Manage and secure": (0.15, 0.20),
}
questions = 50 # assumption for illustration only
for area, (lo, hi) in weights.items():
print(f"{area:<24} ~{lo*questions:.0f}-{hi*questions:.0f} questions")
# Prepare the data ~12-15 questions
# Model the data ~12-15 questions
# Visualize and analyze ~12-15 questions
# Manage and secure ~8-10 questions
The lesson: the three big sections are about equal in weight. Many people who come from Excel feel confident about visuals and skimp on DAX modelling. Don't. A whole quarter of the exam sits there. "Manage and secure" is smaller, but 8 to 10 questions can still decide whether you pass.
GA versus Preview features
The guide says that most questions cover features that are generally available (GA). It also says the exam may include Preview features if those features are commonly used. So study features that have shipped first, and don't write off a Preview feature that everyone already uses.
Question formats you may meet
Microsoft doesn't say ahead of time which formats a particular exam will use. The sandbox shows the possible types: multiple choice, drag and drop, build list (putting steps in order), hot area (clicking part of an image), active screen, and case studies. A case study is a longer scenario about a fictional company, followed by several questions. Practical points:
- On role-based exams like PL-300, you can open Microsoft Learn inside the exam, but the clock keeps running. Use it for one detail you need to check, not to look up every question.
- You can take a break, but the clock keeps running. You also can't go back to any question you saw before the break.
- No penalty for guessing means you should never leave a question blank.
Elimination strategy: a worked sample question
You import a sales CSV into Power BI Desktop. Some rows are completely blank, and they inflate the row count of the Sales table. You need to prevent the blank rows from loading into the model, using the least effort. What should you do? A. Create a DAX measure that uses COUNTROWS and ignores blanks B. In Power Query Editor, select Remove Rows > Remove Blank Rows C. Add a visual-level filter that excludes blanks on each visual D. Apply conditional formatting to hide blank rows
Work through it in four steps:
- Find the requirement and the constraint. The requirement is "prevent... from loading into the model". The constraint is "least effort".
- Cross out options that fail the requirement. A, C and D all act after the data has loaded. The blank rows would still be in the table. A measure, a filter or some formatting only hides the problem.
- Compare what's left against the constraint. Only B is left, and it's a single click.
- Pick B. Power Query records the step as M code:
// Step that Power Query generates for Remove Blank Rows
= Table.SelectRows(#"Changed Type",
each not List.IsEmpty(
List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
// It keeps a row only if at least one field is neither empty text nor null
You'll see three question styles again and again:
- "Best answer" scenarios. Several options could work. Words like least effort or minimize decide which one is best.
- Product-contrast questions. You have to choose the right tool or layer, such as Power Query versus DAX versus a visual.
- Recognition questions. You have to know the exact name of a feature or setting.
What the exam asks about this
The exam won't ask you about its own logistics. What this level gives you is how to plan and how to take the exam. The objective domains, the weightings and the habit of spotting the constraint will matter on every question that follows. The next level starts the syllabus itself: connecting to data sources and shared semantic models.
Key takeaways
- The study guide, Practice Assessment and exam sandbox are Microsoft's and free on Microsoft Learn. This course follows them but doesn't copy them.
- You get 100 minutes, and you need a scaled score of 700 out of 1,000. That isn't the same as 70%.
- The weightings are 25–30% each for Prepare, Model and Visualize/analyze, and 15–20% for Manage and secure.
- Most questions test GA features. Commonly used Preview features may also appear.
- There's no penalty for guessing, so answer everything.
- To eliminate options: find the requirement and constraint, cross out what fails, then choose the best of what's left.
- This course is independent of Microsoft and can't guarantee a pass.