PL-300 Study Guide
A curated learning path for the PL-300 exam: the best documentation, videos, blog posts and tutorials for every exam objective.A curated learning path for the PL-300 exam: the best documentation, videos, blog posts and tutorials for every exam objective, in the order worth studying them.
Microsoft Certified: Power BI Data Analyst Associate
Exam at a Glance
PL-300 measures whether you can do the day-to-day work of a Power BI data analyst: getting and cleaning data in Power Query, building a sound semantic model with DAX, turning it into reports that people actually use, and publishing, securing and maintaining that content in the Power BI service.
| PL-300 | Microsoft Power BI Data Analyst |
|---|---|
| Level | Intermediate (associate role-based exam) |
| Exam length | 100 minutes |
| Questions | Typically 40 to 60; the number and format mix can vary |
| Passing score | 700 out of 1000 |
| Question formats | Multiple choice, multiple select, drag and drop, build list, hot area, case studies |
| Microsoft Learn access | Available within the exam; browsing is restricted and the timer continues |
| Skills measured version | April 20, 2026 |
| Renewal | Certification expires annually; renew with a free online assessment on Microsoft Learn |
What the Exam Covers
Four domains: preparing, modeling and visualizing data at 25-30% each, and managing and securing Power BI at 15-20%, where candidates who only work in Power BI Desktop lose the most points. Most questions describe a scenario and turn on a design decision: a storage mode, a relationship, a measure, a visual or a security setting.
Prepare the data — 25-30%
Connecting to data sources and shared semantic models, credentials and privacy levels, and choosing between Direct Lake, DirectQuery and Import. Then profiling and cleaning (column statistics, nulls, import errors) and transforming in Power Query: data types, grouping, pivot and unpivot, semi-structured data, fact and dimension tables, reference versus duplicate queries, merge and append, and load configuration.
Model the data — 25-30%
Relationship cardinality and cross-filter direction, role-playing dimensions, a common date table, and calculated columns and tables. DAX covers aggregation measures, CALCULATE, time intelligence, statistical functions, semi-additive measures and calculation groups. Optimization means removing unnecessary rows and columns, reducing granularity, and finding slow measures, relationships and visuals with Performance Analyzer and DAX query view.
Visualize and analyze the data — 25-30%
Selecting and formatting visuals, conditional formatting, slicing and filtering, paginated reports, visual calculations, and Copilot for narrative visuals and report pages. Usability covers bookmarks, tooltips, drillthrough, sync slicers, mobile layouts, accessibility and automatic page refresh. Analysis covers the Analyze feature, grouping, binning and clustering, AI visuals, forecasting, and outliers and anomalies.
Manage and secure Power BI — 15-20%
Workspaces and apps, publishing and distributing content, subscriptions and data alerts, promoting and certifying content, when a gateway is required, and scheduled refresh. Security covers workspace roles, item-level and semantic-model access, row-level security roles and group membership, and sensitivity labels.
The full bullet list is in Microsoft's study guide, linked in Step 1 below.
How This Maps to CertiAce Practice Modules
The CertiAce practice modules follow the five learning paths of Microsoft's PL-300 course:
| CertiAce practice module | What you will drill there |
|---|---|
| Get started with Microsoft data analytics | The analyst role, Power BI building blocks, how Desktop, the service and Fabric fit together |
| Prepare data for analysis with Power BI | Data sources, storage modes, profiling, cleaning, transforming and loading data in Power Query |
| Model data with Power BI | Star schemas, relationships, DAX measures, time intelligence, calculation groups and model performance |
| Design effective reports in Power BI | Visual selection, formatting, interactions, navigation, accessibility, AI visuals and Copilot |
| Manage and secure Power BI | Workspaces, apps, refresh and gateways, endorsement, roles, row-level security and sensitivity labels |
Where PL-300 Fits

| Certification | What it validates | When to take it |
|---|---|---|
| DP-900: Azure Data Fundamentals | Core data concepts, relational and non-relational data, analytics workloads | Optional first step if you are new to data work |
| PL-300: Power BI Data Analyst Associate (this exam) | Preparing, modeling, visualizing and securing data with Power BI | You are here |
| DP-600: Fabric Analytics Engineer Associate | Enterprise-scale semantic models, warehouses and lakehouses in Microsoft Fabric | The natural next step once you are confident with Power BI modeling |
PL-300 has no prerequisites (the certification page lists none), so it can be your first Microsoft exam. If you are new to data and analytics concepts, starting with DP-900 is a sensible first step: it builds the vocabulary PL-300 assumes, though Microsoft is explicit that it is not required for any role-based certification. Passing PL-300 is not a formal prerequisite for anything either, but it is the recommended entry point for Fabric Analytics Engineer Associate (DP-600), which builds directly on the semantic-model and DAX skills tested here, and the DP-600 guide recommends PL-300 first for the same reason.
Before You Start
The exam assumes practical experience delivering analytics with Power BI, not just reading about it. Anything unfamiliar in this table is where to start:
| Area | You should be comfortable with |
|---|---|
| Power BI Desktop and the service | Navigating Desktop and the service, connecting to common sources, publishing a report, what workspaces, apps and dashboards are for |
| Data preparation | Shaping and cleaning data in Power Query, changing data types, merging and appending queries, spotting bad or missing values |
| Data modeling | Fact and dimension tables in a star schema, creating relationships, the difference between a measure and a calculated column, writing a basic DAX measure |
| Report design | Choosing and formatting common visuals, adding slicers and filters, making a page readable on first glance |
| Data and business basics | Relational data concepts, reading a simple query, and turning a stakeholder question into a metric |
Commonly Confused Pairs
These pairs tend to show up together as the two plausible answers to one question:
| Looks similar | The difference that decides the answer |
|---|---|
| Append or Merge | Append stacks the rows of one or more queries under another and matches columns by name, so a column missing from one table fills with null. Merge joins two queries on matching values in one or more columns, and you then expand or aggregate the columns that come from the second query. |
| Distinct or Unique in column distribution | Distinct counts how many different values a column holds. Unique counts only the values that appear exactly once. Both are profiled over the first 1,000 rows unless you switch column profiling to the entire data set. |
| Calculated column or measure | In an Import model, a calculated column is computed row by row at data refresh and stored, which adds to the model's size. A measure is computed on demand in the filter context of the visual and isn't stored, so it responds to slicers and filters. |
| Import or DirectQuery | Import stores a snapshot of the data in the model, so visuals show source changes only after a refresh. DirectQuery queries the source when visuals load and stores no data, so results are closer to real time, but queries can be slower and some modeling features are limited. |
| Drill down or drillthrough | Drill down moves through the levels of a hierarchy inside the same visual, and the rest of the page doesn't change. Drillthrough takes you to a different report page filtered to the value you selected. |
| Gateway standard mode or personal mode | A standard on-premises data gateway is shared by multiple users and works with all supported services. Personal mode serves one user, works only with Power BI and supports only Import semantic models with scheduled or on-demand refresh, so it rules out DirectQuery and live connections. |
Step-by-Step Study Plan

Treat these estimates as planning guidance and adjust them to your starting knowledge and weekly study hours:
| Your starting point | Suggested prep time |
|---|---|
| Building Power BI reports weekly | 2 to 4 weeks |
| You know Excel and data, but are new to Power BI | 4 to 6 weeks |
| New to both data analysis and Power BI | 6 to 10 weeks |
Step 1: Read the Official Study Guide
Skim the full skills-measured list once, and mark every bullet you could not explain to a colleague. Note the version: the April 20, 2026 list includes Copilot features, Direct Lake, visual calculations and paginated reports, topics that older courses and blog posts predate entirely.
Step 2: Schedule Your Exam
Choose a realistic target date after reviewing the skills list and your available study time, then work backwards from it with the prep-time table above.
Certification and Exam Details Page
Step 3: Work Through the Official Learning Path
Complete the PL-300 course modules on Microsoft Learn: five learning paths that match the five CertiAce practice modules one-to-one. Write down every concept you cannot explain in simple terms, and flag the ones to practice in Step 5. Pay special attention to storage modes, relationships, DAX filter context and row-level security: they are where scenario questions turn.
Official Learning Path Course Page
Step 4: Watch a Full Video Course
Microsoft Learn publishes its own PL-300 video series on YouTube: twenty videos, about three and a half hours in total, that walk the official course module by module, from getting and cleaning data through semantic models and DAX to report design, row-level security and Copilot. Watch it end to end, replicating the key actions in Power BI Desktop, then rewatch individual videos for your weak modules. Microsoft's four-part Exam Readiness Zone series in the resources below adds exam strategy per domain.
PL-300: Microsoft Power BI Data Analyst (Microsoft Learn on YouTube)
Step 5: Get Hands-On Practice
PL-300 rewards real experience building analytics solutions. Power BI Desktop is free and is the tool for data preparation, modeling and report authoring. Workspaces, publishing, apps and collaboration happen in the Power BI service: use existing service licenses or the Fabric trial listed below, which includes a Power BI individual trial if you do not already have a Premium Per User license. Fabric trial capacity does not support Copilot, so cover those objectives from the documentation or a demonstration unless you have a supported paid capacity. The official PL-300 lab exercises are free and self-paced. Make sure you personally touch:
- Connecting to sources, choosing Import or DirectQuery, and cleaning data in Power Query with merge and append
- Building a star schema with relationships and a date table
- Writing DAX measures and watching filter context change them
- Creating and formatting visuals, slicers, bookmarks and drillthrough
- Publishing to the service, then configuring scheduled refresh, row-level security and an app
Step 6: Benchmark Your Knowledge
Use CertiAce to benchmark your readiness module by module. The practice modules map to the exam domains as shown above, so use the module mapping and the topics behind your missed questions to identify the skills-measured areas to revisit. Microsoft also offers a free official practice assessment for PL-300 on Microsoft Learn (sign in to launch it). It is a useful extra check, but it tends to be somewhat easier than the real exam. CertiAce questions are written to sit closer to the real exam's difficulty. If a module stays weak, read the explanations on the questions you missed, then retry that module.
Official Practice Assessment for PL-300
Step 7: Take the Exam
The day before, review only your weak topics. In the exam, watch for wording that implies a constraint such as performance, security, cost, or self-service, and notice which domain the scenario sits in. That alone often eliminates half the options.
- Microsoft Learn is available during the exam in a split screen. Use it to check details you genuinely need: the timer keeps running, and the exam is deliberately too long to look up every answer. Browsing is limited to Microsoft Learn itself (no Q&A, practice assessments, or profile), and personal notes and other websites are unavailable.
- You can take unscheduled breaks, but the clock keeps running and you cannot return to questions you already saw.
- Case studies lock when you leave them: finish each one before moving on, because you cannot revisit its questions afterwards.
- Try the exam sandbox beforehand so the question formats and interface hold no surprises: Exam Sandbox
Additional Learning Resources
| Resource | Type | Why it is useful |
|---|---|---|
| PL-300: Microsoft Power BI Data Analyst | YouTube playlist | Microsoft Learn's official 20-video series (about 3.5 hours), one video per course module |
| Preparing for PL-300 - Prepare the Data (Part 1 of 4) | Video series | Microsoft's Exam Readiness Zone series: one episode per domain on how the exam frames each objective |
| Get Certified (PL-300): Become a Certified Power BI Data Analyst | Microsoft Reactor series | Five-session livestream series with on-demand recordings, ending with exam-day preparation and open Q&A |
| Get ready to pass Exam PL-300 | Learn collection | Microsoft's official curated collection of preparation material |
| Download Power BI Desktop | Docs | The free desktop tool for data preparation, modeling and report authoring |
| Try Microsoft Fabric for free | Docs | A 60-day trial capacity plus a Power BI individual trial for practicing workspaces, apps, refresh and security in the service |
| Guy in a Cube | YouTube channel | Short practical videos from Microsoft's Power BI team on modeling, DAX, storage modes and the service |
| Microsoft Power BI | YouTube channel | The official product channel: monthly update videos and feature demos, useful for the newest Copilot and visual features |
| SQLBI | Blog | Marco Russo and Alberto Ferrari's free DAX and modeling articles, plus a free introductory DAX video course |
| DAX Guide | Docs | SQLBI's function-by-function DAX reference with examples |
| PL-300: Power BI Exam Prep: Connecting to data sources | Blog | Reza Rad's PL-300 prep series, starting with the data-source objectives |
| Chris Webb's BI Blog | Blog | Deep dives on Power Query, DAX, storage modes and refresh from a Microsoft engineer |
| Power BI documentation | Docs | The source of truth the exam draws from, including the Power Query and guidance sections |
| Data Analysis Expressions (DAX) Reference | Docs | The official DAX function and syntax reference |
Realistic PL-300 exam-style questions with instant feedback and detailed explanations.
Practice PL-300 now