PL-300STUDY GUIDEFree
Guides

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.

Microsoft Certified: Power BI Data Analyst Associate

01

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-300Microsoft Power BI Data Analyst
LevelIntermediate (associate role-based exam)
Exam length100 minutes
QuestionsTypically 40 to 60; the number and format mix can vary
Passing score700 out of 1000
Question formatsMultiple choice, multiple select, drag and drop, build list, hot area, case studies
Microsoft Learn accessAvailable within the exam; browsing is restricted and the timer continues
Skills measured versionApril 20, 2026
RenewalCertification expires annually; renew with a free online assessment on Microsoft Learn
02

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 moduleWhat you will drill there
Get started with Microsoft data analyticsThe analyst role, Power BI building blocks, how Desktop, the service and Fabric fit together
Prepare data for analysis with Power BIData sources, storage modes, profiling, cleaning, transforming and loading data in Power Query
Model data with Power BIStar schemas, relationships, DAX measures, time intelligence, calculation groups and model performance
Design effective reports in Power BIVisual selection, formatting, interactions, navigation, accessibility, AI visuals and Copilot
Manage and secure Power BIWorkspaces, apps, refresh and gateways, endorsement, roles, row-level security and sensitivity labels
03

Where PL-300 Fits

Certification path. Fundamentals: DP-900; Associate: PL-300 (this exam), DP-600.
The Power BI data analyst path, from DP-900 to PL-300
CertificationWhat it validatesWhen to take it
DP-900: Azure Data FundamentalsCore data concepts, relational and non-relational data, analytics workloadsOptional 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 BIYou are here
DP-600: Fabric Analytics Engineer AssociateEnterprise-scale semantic models, warehouses and lakehouses in Microsoft FabricThe 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.

Microsoft Certified: Power BI Data Analyst Associate

04

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:

AreaYou should be comfortable with
Power BI Desktop and the serviceNavigating Desktop and the service, connecting to common sources, publishing a report, what workspaces, apps and dashboards are for
Data preparationShaping and cleaning data in Power Query, changing data types, merging and appending queries, spotting bad or missing values
Data modelingFact and dimension tables in a star schema, creating relationships, the difference between a measure and a calculated column, writing a basic DAX measure
Report designChoosing and formatting common visuals, adding slicers and filters, making a page readable on first glance
Data and business basicsRelational data concepts, reading a simple query, and turning a stakeholder question into a metric
05

Commonly Confused Pairs

These pairs tend to show up together as the two plausible answers to one question:

Looks similarThe difference that decides the answer
Append or MergeAppend 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 distributionDistinct 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 measureIn 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 DirectQueryImport 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 drillthroughDrill 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 modeA 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.
06

Step-by-Step Study Plan

Study plan in three phases: plan (steps 1 and 2), learn and build (steps 3 to 5), prove it (steps 6 and 7). Retry weak modules at step 6.
The PL-300 study plan: seven steps in three phases

Treat these estimates as planning guidance and adjust them to your starting knowledge and weekly study hours:

Your starting pointSuggested prep time
Building Power BI reports weekly2 to 4 weeks
You know Excel and data, but are new to Power BI4 to 6 weeks
New to both data analysis and Power BI6 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.

The Official Study Guide

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

Official PL-300 Lab Exercises

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.

CertiAce PL-300 Exam Practice

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
07

Additional Learning Resources

ResourceTypeWhy it is useful
PL-300: Microsoft Power BI Data AnalystYouTube playlistMicrosoft 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 seriesMicrosoft'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 AnalystMicrosoft Reactor seriesFive-session livestream series with on-demand recordings, ending with exam-day preparation and open Q&A
Get ready to pass Exam PL-300Learn collectionMicrosoft's official curated collection of preparation material
Download Power BI DesktopDocsThe free desktop tool for data preparation, modeling and report authoring
Try Microsoft Fabric for freeDocsA 60-day trial capacity plus a Power BI individual trial for practicing workspaces, apps, refresh and security in the service
Guy in a CubeYouTube channelShort practical videos from Microsoft's Power BI team on modeling, DAX, storage modes and the service
Microsoft Power BIYouTube channelThe official product channel: monthly update videos and feature demos, useful for the newest Copilot and visual features
SQLBIBlogMarco Russo and Alberto Ferrari's free DAX and modeling articles, plus a free introductory DAX video course
DAX GuideDocsSQLBI's function-by-function DAX reference with examples
PL-300: Power BI Exam Prep: Connecting to data sourcesBlogReza Rad's PL-300 prep series, starting with the data-source objectives
Chris Webb's BI BlogBlogDeep dives on Power Query, DAX, storage modes and refresh from a Microsoft engineer
Power BI documentationDocsThe source of truth the exam draws from, including the Power Query and guidance sections
Data Analysis Expressions (DAX) ReferenceDocsThe official DAX function and syntax reference
READY TO TEST YOURSELF?
Practice what you just studied

Realistic PL-300 exam-style questions with instant feedback and detailed explanations.

Practice PL-300 now