Certification Guide · Updated July 2026

PL-300 Exam Guide 2026: Microsoft Power BI Data Analyst Associate

PL-300 is Microsoft’s entry-point certification for Power BI professionals — the most in-demand credential in the entire Microsoft data ecosystem. This guide covers every exam domain, the skills measured as of April 20, 2026, a 6-week study plan with hands-on practice links, PL-300 vs DP-600, and everything you need to pass first time.

What is the PL-300 exam?

PL-300 (Microsoft Power BI Data Analyst) is the Microsoft Certified: Power BI Data Analyst Associate exam. It validates your ability to prepare, model, visualize, and analyze data, and to manage and secure Power BI assets. The exam is 100 minutes, roughly 40–60 questions, passing score 700/1000, and costs approximately USD $165. It covers four domains: Prepare the data (25–30%), Model the data (25–30%), Visualize and analyze the data (25–30%), and Manage and secure Power BI (15–20%). (per Microsoft Learn official exam page)

700 Pass Score (out of 1000)
100 Minutes
$165 Exam Cost (USD)
12 mo Validity (free renewal)
📅 Skills measured as of: April 20, 2026 Read time: ~17 min ✍️ A.J., Data Engineering Researcher 🔗 Official PL-300 Study Guide

What the PL-300 Exam Is and Why It Matters in 2026

PL-300 is Microsoft’s flagship Power BI certification and, by most third-party estimates, one of the highest-search-volume Microsoft certification exams in the entire catalog. It’s officially titled Microsoft Power BI Data Analyst, and passing it earns you the Microsoft Certified: Power BI Data Analyst Associate credential — the credential that replaced the older DA-100 exam.

Unlike DP-600 or DP-700, PL-300 doesn’t assume you’re working across the full Fabric platform. It’s scoped tightly to Power BI itself: connecting to data, shaping it with Power Query, building a data model with DAX, designing reports people actually want to use, and securing what you publish. It’s the certification most Power BI professionals take first — and the one hiring managers expect by default for any analyst-facing BI role.

Who Should Take PL-300

  • Business/data analysts who build reports and dashboards in Power BI
  • Excel power users transitioning into self-service BI roles
  • Consultants who need a recognized, in-demand credential for client-facing work
  • Career switchers targeting data analyst roles — PL-300 has no formal prerequisites
  • Future DP-600 candidates — Microsoft’s own DP-600 training recommends PL-300 (or equivalent experience) first
📌

PL-300 vs the Old DA-100

DA-100 (Analyzing Data with Microsoft Power BI) was retired in 2022 and replaced by PL-300. The scope is similar — prepare, model, visualize, secure — but PL-300 has been revised repeatedly since to include Fabric-era concepts (DirectLake as a storage mode option, OneLake-aware semantic models) and, most recently, Copilot-assisted report authoring. If you’re studying from an old DA-100 guide, the content is meaningfully out of date.

Certification Validity and Renewal

PL-300 is valid for 12 months from the date you pass. Microsoft sends a renewal reminder before expiration. The renewal assessment is free, online, open-book (Microsoft Learn access), and takes approximately 30 minutes — it tests what’s changed in Power BI since your last pass, not a full re-exam.

PL-300 Exam Domains — Skills Measured as of April 20, 2026

Four domains. Three are weighted equally at 25–30%, with “Manage and secure Power BI” carrying the least weight at 15–20%. That doesn’t mean you can skip it — row-level security and workspace governance questions show up reliably — but it does mean your deepest study time should go toward data preparation, modeling, and visualization.

25–30%

Domain 1 — Prepare the Data

  • Connect to data sources or a shared semantic model
  • Choose between DirectLake, DirectQuery, and Import
  • Profile data — statistics, column properties, quality issues
  • Resolve nulls, inconsistencies, and import errors
  • Transform: data types, grouping, pivot/unpivot, merge/append
  • Create fact and dimension tables; identify relationship keys
25–30%

Domain 2 — Model the Data

  • Configure table/column properties; role-playing dimensions
  • Define relationship cardinality and cross-filter direction
  • Create a common date table
  • Write DAX measures — CALCULATE, time intelligence, semi-additive
  • Create calculation groups and quick measures
  • Optimize model performance with Performance Analyzer / DAX query view
25–30%

Domain 3 — Visualize and Analyze the Data

  • Select and format appropriate visuals; apply themes
  • Create a narrative visual and report pages with Copilot
  • Configure bookmarks, tooltips, interactions, drillthrough
  • Design reports for mobile and for accessibility
  • Use AI visuals, grouping, binning, forecasting, outlier detection
  • Create visual calculations using DAX
15–20%

Domain 4 — Manage and Secure Power BI

  • Create/configure workspaces and apps
  • Configure subscriptions, data alerts, semantic model refresh
  • Promote or certify Power BI content; identify gateway needs
  • Assign workspace roles; configure item-level access
  • Implement row-level security roles and group membership
  • Apply sensitivity labels
⚠️

Always Check the Current Skills Measured Document

The domains above reflect the skills measured document effective April 20, 2026 (last updated on Microsoft Learn March 20, 2026). The change log shows minor updates to “Get or connect to data” and “Enhance reports for usability and storytelling” — largely additions around Copilot features. Before your exam date, verify the current version at the official PL-300 study guide page.

PL-300 vs DP-600 vs DP-700 — Which Certification Should You Take?

FactorPL-300 — Power BI Data AnalystDP-600 — Fabric Analytics EngineerDP-700 — Fabric Data Engineer
Target roleReport/dashboard builder, self-service BIAnalytics engineer bridging data + BIData engineer, pipeline architect
ScopePower BI onlyFull Fabric analytics stackFull Fabric data engineering stack
Heaviest domainEven split — 25–30% × 3Prepare data (45–50%)Even split, ~30–35% each
DAX depthCore measures, time intelligence, calc groups introCalculation groups, field parameters, iterators, windowingNot tested
SQL / KQLNot coveredIncluded — query and analyze dataIncluded — Eventstream/Eventhouse
Direct Lake depthStorage-mode choice onlyCore exam topic — fallback, refresh, storage modesLighter coverage
PrerequisitesNonePL-300 or equivalent recommendedNone, but data engineering experience assumed
Pass score700 / 1000700 / 1000700 / 1000
Exam duration100 minutes100 minutes100 minutes
Cost (USD)~$165~$165~$165

Simple Decision Rule

PL-300 is almost always the right starting point — no prerequisites, tightly scoped to Power BI, and the credential most analyst job postings explicitly name. Once you’re comfortable with DAX and Power Query and want to own enterprise-scale semantic models, Direct Lake performance, and cross-Fabric data prep, move to DP-600. If your role expands into pipelines and Spark, add DP-700 after that. See our DP-600 Exam Guide and DP-700 Exam Guide for the next steps.

Key Technical Topics You Must Know for the PL-300 Exam

These are the specific Power BI capabilities that appear consistently in exam questions based on the official skills measured document. Use this as your study checklist — DAX and data modeling scenarios are consistently reported as the hardest sections, so weight your practice time accordingly.

🧮
Core DAX & CALCULATEFilter context manipulation, time intelligence measures, semi-additive measures, quick measures.
🗂️
Calculation GroupsIntroduced in PL-300’s Domain 2 — full depth (dynamic format strings, calculation items) is a DP-600 topic, but PL-300 tests the fundamentals. See our Calculation Groups Guide.
🔗
Data ModelingStar schema design, relationship cardinality, cross-filter direction, role-playing dimensions, common date tables.
🧹
Power Query TransformationsMerge/append queries, pivot/unpivot, semi-structured data, data type conversion, reference vs. duplicate queries.
Storage ModesChoosing between DirectLake, DirectQuery, and Import — including when Direct Lake falls back. See our Direct Lake Fallback Fix.
🤖
Copilot-Assisted AuthoringNarrative visuals, Copilot-generated report pages and content suggestions — a genuinely new objective area. See our AI in Power BI Guide and DAX with AI Guide.
🎨
Report Design & StorytellingBookmarks, custom tooltips, drillthrough, sync slicers, mobile layout, accessibility configuration.
📈
Analyze FeaturesGrouping, binning, clustering, forecasting, reference lines, error bars, AI visuals, outlier/anomaly detection.
🔐
Row-Level SecurityRLS role creation, DAX filter expressions, group membership assignment — one of the most consistently tested Domain 4 topics.
🗃️
Workspaces & DistributionWorkspace roles, apps, publishing, subscriptions, data alerts, gateway requirements, scheduled refresh.
🏷️
Governance BasicsSensitivity labels, content certification/promotion, item-level access configuration.
📄
Semantic Model AssetsShared semantic models, .pbit template files, .pbids data source files — reusable asset patterns.

Candidates consistently underestimate how much of PL-300 is Power Query, not DAX. “Prepare the data” and parts of “Model the data” both lean on Power Query transformations — merge/append, pivot/unpivot, semi-structured-to-table conversion. If your practice has been 90% DAX and 10% Power Query, rebalance before exam day.

6-Week PL-300 Study Plan — With Hands-On Practice Links

This plan assumes 1–2 hours of study per day and some existing Power BI familiarity. Candidates completely new to Power BI should extend the plan to 8–10 weeks and spend extra time simply building reports from public datasets before layering on DAX complexity.

Week 1
Connect, Profile, and Clean Data with Power Query Connect to several data source types, configure privacy levels and credentials, and practice profiling data with column statistics. Resolve nulls, inconsistencies, and import errors. This is Domain 1 groundwork — get comfortable in the Power Query Editor before anything else.
Week 2
Transform Data and Build Fact/Dimension Tables Practice grouping, aggregating, pivoting, unpivoting, and transposing data. Merge and append queries; understand when reference vs. duplicate queries matter. Build a clean star schema — separate fact tables from dimension tables and identify the correct relationship keys.
Week 3
Data Modeling — Relationships, Date Tables, and DirectLake Configure table and column properties, implement role-playing dimensions, and set relationship cardinality and cross-filter direction correctly. Build a common date table. Compare DirectLake, DirectQuery, and Import — know exactly when each is the right choice.
Week 4
DAX — Measures, Time Intelligence, and Calculation Groups This is the highest-leverage week. Write measures using CALCULATE, implement time intelligence (YTD, prior period, rolling averages), build semi-additive measures, and create your first calculation group. Practice with the DAX query view and Performance Analyzer to spot poorly performing measures.
Week 5
Visualize, Analyze, and Author with Copilot Build full reports: select appropriate visuals, apply conditional formatting, configure bookmarks and custom tooltips, set up drillthrough and sync slicers. Practice Copilot-assisted report authoring — narrative visuals and Copilot-generated pages are newer objectives many older study guides miss entirely. Use grouping, binning, forecasting, and outlier detection.
Week 6
Manage, Secure, and Practice Questions Configure workspaces, apps, and content distribution. Set up scheduled refresh and gateway configuration. Implement row-level security roles and group membership, and apply sensitivity labels. Finish with the Microsoft Learn free practice assessment — identify weak domains and revisit them before scheduling.

Free Practice Assessment on Microsoft Learn

Microsoft provides a free PL-300 practice assessment on the official exam page. Take it at the start of Week 1 to baseline your knowledge gaps, and again at the end of Week 6 to verify readiness before scheduling. Pay particular attention to DAX and modeling scenario questions — they’re consistently reported as the hardest section.

PL-300 Exam Format — What to Expect on Exam Day

FactorDetail
Duration100 minutes total. Budget extra time before the timer starts for instructions, survey, and NDA acknowledgment.
Question countApproximately 40–60 questions. Exact count varies per exam instance.
Question typesMultiple choice, multiple select, drag-and-drop ordering, and case studies (multi-page scenarios with several related questions). May include interactive lab-style components.
Passing score700 out of 1000 on Microsoft’s scaled scoring. Not a raw percentage — it adjusts for question difficulty.
Microsoft Learn accessSplit-screen access to Microsoft Learn is available during the exam, restricted to the learn.microsoft.com domain. Use for DAX function syntax lookups, not as a primary information source.
Exam deliveryPearson VUE — test center or online proctored (OnVUE). Online proctoring requires a clear desk, no second monitor, no phone.
LanguagesEnglish, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Chinese (Traditional), Italian.
ResultPass/fail displayed immediately after submission. Full score report available in your Microsoft Learn profile within 24 hours.
Retake policyIf you fail, you must wait 24 hours before retaking. Subsequent retake waits extend per Microsoft’s standard policy.
RenewalFree renewal assessment on Microsoft Learn, available before your 12-month expiration. Approximately 30 minutes, open-book.

Exam Day Tips and Common Mistakes to Avoid

Before You Sit the Exam

  • Don’t neglect Power Query. A large share of Domain 1 and part of Domain 2 tests transformation skills, not DAX. Practice building end-to-end queries, not just measures.
  • Check the skills measured document one week before. Confirm no new Copilot-related objectives were added since you started studying — this area has been actively expanding.
  • Use the Exam Sandbox on the Microsoft Learn exam page. It shows the actual exam UI — get comfortable with navigation and question review before the real thing.

During the Exam

  • Tackle case studies first. They appear early and typically cannot be revisited. Read all requirements and exhibits before answering any question inside a case study.
  • Use Microsoft Learn strategically. Split-screen access is available — use it for exact DAX function syntax, not to look up every answer.
  • Watch for “most efficient” and “least effort” qualifiers. Many PL-300 questions have multiple technically-correct options; the right answer is usually the one that best matches the stated constraint (performance, maintainability, minimal steps).

Common Failure Points

  • Weak DAX filter-context understanding: CALCULATE and filter context trip up more candidates than any other single topic. Practice until it’s second nature, not memorized.
  • Confusing storage modes: Know precisely when DirectLake, DirectQuery, or Import is the right answer — including the tradeoffs each one makes.
  • Underestimating row-level security: RLS role creation and group membership configuration is a reliably tested Domain 4 topic that’s easy to skip while focused on DAX.
  • Studying from outdated material: Guides based on the old DA-100 exam or pre-2025 PL-300 versions miss the newer Copilot-authoring objectives entirely.
📌

Interview Questions as Additional Exam Prep

UIG Data Lab’s Power BI interview question bank covers scenario-based questions on DAX, modeling, and report design that closely parallel PL-300 exam case studies — a useful way to test your knowledge before the real exam.

Frequently Asked Questions — PL-300 Exam Guide

What is the PL-300 exam?
PL-300 is the Microsoft Certified: Power BI Data Analyst Associate exam — officially titled “Microsoft Power BI Data Analyst.” It validates your ability to prepare, model, visualize, and analyze data, and to manage and secure Power BI assets. It is 100 minutes, roughly 40–60 questions, passing score 700/1000, and costs approximately USD $165. It replaced the older DA-100 exam.
What are the four PL-300 exam domains?
As of April 20, 2026: (1) Prepare the data (25–30%) — connecting to sources, profiling, cleaning, and transforming data with Power Query; (2) Model the data (25–30%) — relationships, DAX measures, calculation groups, and performance optimization; (3) Visualize and analyze the data (25–30%) — report building, Copilot-assisted authoring, bookmarks, and identifying patterns; (4) Manage and secure Power BI (15–20%) — workspaces, row-level security, sensitivity labels, and content distribution.
What is the PL-300 pass score?
700 out of 1000 on Microsoft’s scaled scoring system, the same threshold used across Microsoft’s associate-level exams. This is not a raw percentage — the scaled score adjusts for question difficulty across different exam instances.
What is the difference between PL-300 and DP-600?
PL-300 (Power BI Data Analyst) focuses on report building, core DAX, data modeling fundamentals, and self-service analytics inside Power BI. DP-600 (Fabric Analytics Engineer) goes considerably deeper — enterprise-scale semantic models, advanced DAX (calculation groups, iterators, windowing), Direct Lake configuration, and data preparation using SQL and KQL across the wider Fabric platform. PL-300 is the entry point; DP-600 is the senior, Fabric-wide credential most teams expect after it. See our DP-600 Exam Guide.
Are there any prerequisites for PL-300?
No formal prerequisites. PL-300 is an associate-level, entry-point certification. Microsoft recommends being proficient with Power Query and DAX before attempting it, and hands-on experience building real Power BI reports matters far more than any prior certification.
How long does it take to prepare for PL-300?
Most candidates with a few months of hands-on Power BI experience need 4–6 weeks of focused study at 1–2 hours per day. Candidates completely new to Power BI should plan 8–10 weeks. DAX (CALCULATE, time intelligence, calculation groups) and data modeling scenarios are consistently the hardest sections — prioritize hands-on practice over passive reading.
How much does the PL-300 exam cost and how long is it valid?
The PL-300 exam costs approximately USD $165 in most regions, in line with Microsoft’s standard associate-level exam pricing; exact cost varies by country. The certification is valid for 12 months from the date you pass and renews for free through a short Microsoft Learn assessment (about 30 minutes, open-book).

Official Resources and All UIG Study Links

Official Microsoft Resources

UIG Data Lab — Complete Study Library by Domain

Every article below maps to specific PL-300 exam domains and topics. Use the study plan above to sequence them.

⚠️ Accuracy Disclaimer

Exam details — domain weights, question count, duration, pass score, and cost — are sourced from the official Microsoft PL-300 exam page and skills measured document (effective April 20, 2026). Microsoft updates exam content regularly. Always verify the current skills measured document before your exam date. UIG Data Lab is an independent publication, not affiliated with or endorsed by Microsoft Corporation.

AJ
A.J. Data Engineering Researcher & Technical Writer · UIG Data Lab All articles →

A.J. researches and writes about data engineering, analytics architecture, Microsoft Fabric, and modern cloud data platforms. Coverage spans Microsoft Fabric, Power BI, Azure Data Engineering, Databricks, Snowflake, Apache Spark, dbt, Apache Airflow, and modern cloud data infrastructure. The focus is practitioner-level content that helps data professionals understand platform capabilities, evaluate technology decisions, optimize costs, and implement practical solutions using official documentation, product updates, community insights, and industry best practices. His writing covers real decisions from real deployments — not documentation rewrites.

PL-300 Power BI DAX Power Query Data Analyst Certification Microsoft Fabric Row-Level Security Copilot DP-600
Scroll to Top