Home › Certifications › PL-300 Certification Guide
Microsoft Certification Guide · 2026PL-300 Certification Guide 2026: Microsoft Power BI Data Analyst
Everything about the PL-300 exam — all four domains and weightings, why three of them are tied at 27.5% so there is no domain you can safely skip, the Copilot and DirectLake objectives added in the April 2026 refresh, real Power BI analyst salary bands, and a 10-week roadmap.
Authorized Training & Technology Partners
Microsoft
PL-300 — Power BI Data Analyst Associate
The credential this guide covers
PL-300 (Microsoft Power BI Data Analyst) is the most established data credential Microsoft issues and the one hiring managers actually recognise by name. It has four domains, you pass at 700 out of 1000, and it is Associate tier. The thing almost every candidate gets wrong: three of the four domains are weighted identically at 25–30%, so the visuals you enjoy building are worth no more than the Power Query and DAX work you have been avoiding.
And there is a second thing, newer and less widely known. The blueprint was refreshed on 20 April 2026, and that refresh quietly put Copilot and DirectLake on the exam. A great deal of PL-300 prep material still in circulation predates it — which means people are studying for an exam that no longer exists in quite that form.
PL-300 exam at a glance
| Attribute | Detail |
|---|---|
| Exam code | PL-300 — Microsoft Power BI Data Analyst |
| Certification earned | Microsoft Certified: Power BI Data Analyst Associate |
| Level | Associate — the role-based working tier |
| Passing score | 700 out of 1000 |
| Domains | Four — Prepare, Model, Visualize and analyze, Manage and secure |
| Core tooling | Power Query and DAX — the blueprint states you should be proficient at both |
| Skills measured version | Current as of 20 April 2026 |
| Delivery | Pearson VUE — online proctored or at a test centre |
| Prerequisites | None enforced — working familiarity with Power BI is assumed |
| Renewal | Annually — Microsoft associate certifications expire each year, renewed by passing a free online assessment on Microsoft Learn |
| Practice assessment | A free official practice assessment is published on Microsoft Learn |
What is the PL-300 certification?
Microsoft’s audience profile is unusually plain about the job. As a candidate you should deliver actionable insights by working with available data and applying domain expertise — providing business value through easy-to-comprehend visualizations, and enabling others to perform self-service analytics.
Read that second clause again. Enabling others is the part that separates a certified analyst from someone who can build a chart. You work with business stakeholders to pin down requirements, with analytics and data engineers to acquire the data, and then you prepare it, model it, visualize it, and manage and secure it.
Power BI is a pleasant tool to learn in the wrong order. Most self-taught candidates spend their time in the visuals pane, because that is where the work looks like progress. But Prepare and Model together are 50–60% of the exam — Power Query transformations, fact and dimension tables, relationship cardinality and cross-filter direction, CALCULATE, time intelligence, calculation groups. If your DAX stops at SUM and a slicer, the exam will find that out.
PL-300 skills measured and weightings
Four domains. Look at how flat the top three are — that shape is the whole study strategy.
PL-300 exam blueprint — share of exam by domain
Official Microsoft weightings, skills measured as of 20 April 2026. Bars show the midpoint of each range.
Source: Microsoft Learn, “Study guide for Exam PL-300: Microsoft Power BI Data Analyst”, skills measured as of 20 April 2026. Bars use the midpoint of each published range; the three leading domains share an identical 27.5% midpoint.
There is no cheap domain. Three of the four carry the same weight, so a candidate strong in visuals and weak in modelling loses roughly as many marks as the reverse. Even the smallest domain — workspaces, apps, gateways, refresh, row-level security, sensitivity labels — is 15–20%, which is easily the difference between 690 and 720. Allocate study time to the blueprint, not to your comfort zone.
The four domains as flashcards
Prepare the data
Get or connect: identify and connect to sources or a shared semantic model, change source settings including credentials and privacy levels, choose between DirectLake, DirectQuery and Import, create and modify parameters. Profile and clean: data statistics and column properties, resolving inconsistencies, nulls and quality issues, resolving import errors. Transform and load: column data types, created and transformed columns, group and aggregate, pivot/unpivot/transpose, semi-structured data to tables, fact and dimension tables, reference versus duplicate queries, merge and append, keys for relationships.
25–30% · Power QueryModel the data
Design: table and column properties, role-playing dimensions, cardinality and cross-filter direction, a common date table, when to use calculated columns versus calculated tables. DAX: single aggregation measures, CALCULATE, time intelligence, basic statistical functions, semi-additive measures, quick measures, calculation groups. Optimize: remove unnecessary rows and columns, find poor performers with Performance Analyzer and DAX query view, reduce granularity.
25–30% · DAX lives hereVisualize and analyze the data
Create reports: selecting an appropriate visual, formatting, themes, conditional formatting, slicing and filtering, paginated reports, visual calculations using DAX, and a set of Copilot objectives. Usability and storytelling: bookmarks, custom tooltips, visual interactions, navigation, sorting, sync slicers, the Selection pane, drillthrough, export settings, mobile layouts, personalization, accessibility, automatic page refresh. Patterns and trends: the Analyze feature, grouping, binning and clustering, AI visuals, reference lines, error bars and forecasting, outlier and anomaly detection.
25–30% · the widest domainManage and secure Power BI
Workspaces and assets: creating and configuring a workspace, configuring and updating an app, publishing and updating items, dashboards, choosing a distribution method, subscriptions and data alerts, promoting or certifying content, identifying when a gateway is required, scheduled semantic model refresh. Secure and govern: workspace roles, item-level access, semantic model access, row-level security roles and group membership, sensitivity labels.
15–20% · most under-studiedCopilot is now examinable
The April 2026 blueprint names four Copilot tasks outright: create a narrative visual with Copilot, use Copilot to create a new report page, use Copilot to suggest content for a new report page, and use Copilot to summarize the underlying semantic model. If your study material never mentions Copilot, it is out of date — and these are easy marks for anyone who has actually clicked the button.
New · inside domain 3DirectLake — Fabric has arrived
“Choose between DirectLake, DirectQuery, and Import” sits in the very first sub-domain. DirectLake is a Microsoft Fabric storage mode, which means PL-300 is no longer purely a Power BI Desktop exam — you are expected to know when a lakehouse-backed model beats an imported one. This is the single most common gap in older prep courses.
New · inside domain 1Who PL-300 is actually for
- Business and MIS analysts living in Excel who want the move into Power BI to be recognised rather than assumed.
- Reporting and operations staff already producing dashboards, who need the modelling layer underneath them to be sound.
- Career changers into data — PL-300 is the most name-recognised entry credential in analytics, and it is the one that appears in job adverts by code.
- Data engineers who need the presentation half — a natural companion to DP-700 on the Microsoft Fabric side.
Where it will not carry you
- It is not a data engineering credential. Pipelines, lakehouses and warehouse design belong to DP-700, not here.
- It is not a machine learning credential. Forecasting and anomaly detection appear as Power BI features, not as modelling theory.
- Passing does not make you fast. The exam certifies that you know the right approach; only repetition on real, messy data makes you quick at it.
What a Power BI analyst actually earns
PL-300 sits on top of one of the few genuinely mature job markets in this catalogue. Data analyst is an established role with published, stable salary bands — which means the numbers below are role evidence rather than guesswork, and the progression between bands is the real story.
The jump between bands
Excel to Power BI
Report builder to modeller
Analyst to lead
Analyst to Fabric engineer
Power BI and data analyst pay by market
India and the US shown as two separate charts, because rupee and dollar bands are different measures on different scales and should never share an axis.
India — annual CTC
Power BI / data analyst roles, ₹ lakh per annum
Bar length maps the upper bound of each band against a ₹40 L scale. Bands compiled from published Indian data analyst and Power BI developer ranges. Metro roles and product companies sit at the top of each band; service-company roles at the bottom.
United States — annual base
Data analyst and BI analyst roles, US$ thousands
Bar length maps each figure against a $160K scale. Bands compiled from published US data analyst and business intelligence analyst ranges; base pay only, excluding bonus and equity.
These are role bands, not certification outcomes. No credible published figure attaches a specific salary increase to holding PL-300 by itself. What the certification does is make you a legible candidate for the band above — particularly the modelling-heavy roles, where the DAX and semantic-model work that PL-300 forces you to learn is exactly what the interview tests.
Compensation figures are compiled from independent, publicly available industry sources and are shown for role context. They are not a guarantee of pay in any specific market, company or outcome, and 360DT does not promise a salary result from any certification or programme.
Why PL-300 still holds its value in 2026
1. It is the credential that gets named in job adverts
Most AI certifications are too new for recruiters to filter on. PL-300 is not — it has been the Power BI credential long enough that it appears by exam code in job descriptions and in recruiter keyword searches. For a career changer, that recognition is worth more than a newer certification with a more impressive name.
2. The April 2026 refresh moved it toward Fabric and Copilot
DirectLake in the storage-mode objective and four explicit Copilot tasks in the reporting domain mean PL-300 now certifies the current product, not the 2022 one. That matters for a credential’s shelf life: an exam that tracks the platform stays relevant, and this one visibly does.
3. Annual renewal keeps the badge honest
Associate certifications expire every year and renew through a free online assessment on Microsoft Learn. It is a small obligation, and it is the reason a current PL-300 tells an employer something a five-year-old certificate cannot — that you have kept up with a product that changes every month.
4. Self-service analytics is the actual business need
The audience profile asks you to enable others to perform self-service analytics. That is a governance and modelling job as much as a reporting one — a well-built semantic model with row-level security and certified datasets lets a whole department answer its own questions. Organisations pay for that outcome, not for dashboards.
Your 10-week PL-300 roadmap
Weighted to the blueprint, which means Power Query and DAX get the first half. Assume 6–8 hours per week, with real data in front of you rather than a video.
Connecting and storage modes
Connect to files, databases and a shared semantic model. Data source settings, credentials and privacy levels. Parameters. Then the objective people skip: when to choose DirectLake, DirectQuery or Import — understand what each does to refresh, model size and query performance.
Profiling and cleaning
Column quality, distribution and profile. Resolving inconsistencies, unexpected values and nulls. Fixing import errors. Deliberately load a dirty CSV and repair it end to end — this is examined as judgement, not as button-clicking.
Transform and load in Power Query
Data types, created and transformed columns, group and aggregate, pivot, unpivot and transpose, semi-structured data to tables. Fact and dimension tables. Reference versus duplicate queries and what each costs. Merge and append. Keys for relationships. Query load configuration. Completes domain 1.
Model design
Table and column properties. Role-playing dimensions. Cardinality and cross-filter direction — know exactly what a bidirectional relationship does before you ever set one. A common date table. When a calculated column is right and when a measure is right.
DAX, the part that decides your score
Aggregation measures. CALCULATE and filter context until it is genuinely intuitive. Time intelligence. Basic statistical functions. Semi-additive measures. Quick measures. Calculated tables and columns. Calculation groups. Write these, do not read them.
Model performance
Removing unnecessary rows and columns. Finding poor performers with Performance Analyzer and the DAX query view. Reducing granularity. Take a slow report you built in week 5 and make it fast. Completes domain 2.
Building reports
Choosing the right visual for the question. Formatting and configuration, themes, conditional formatting, slicing and filtering. When a paginated report is the correct answer. Visual calculations in DAX. Then the Copilot objectives — narrative visual, creating a page, suggesting content.
Usability, storytelling and analysis
Bookmarks, custom tooltips, visual interactions, navigation, sorting, sync slicers, the Selection pane, drillthrough with pages, filters and buttons, export settings, mobile layouts, personalization, accessibility, automatic page refresh. Then Analyze, grouping, binning and clustering, AI visuals, reference lines, error bars, forecasting, anomaly detection, and Copilot semantic-model summaries. Completes domain 3.
Manage and secure — do not skip this
Workspaces, apps, publishing and updating items, dashboards, distribution methods, subscriptions and data alerts, promoting and certifying content, when a gateway is required, scheduled refresh. Then workspace roles, item-level access, semantic model access, row-level security roles and group membership, sensitivity labels. Completes domain 4 — 15–20% that most candidates under-prepare.
Practice assessment, weak spots, book the exam
Take the free official practice assessment on Microsoft Learn. Score by domain, not overall — a 78% that hides a 55% in modelling is a fail waiting to happen. Rebuild one full project from raw file to secured, published, refreshing app. Then book.
Register with a personal MSA account, not a work or school account. If you change employer, exam records tied to an organisational account are unrecoverable — and with an annually renewing credential, you will need that record more than once.
Learn from Microsoft Certified Trainers
Certification prep at 360DT is delivered live by Microsoft Certified Trainers, Anthropic Authorized Instructors and a Microsoft Business Applications MVP — our full international faculty.
Shantanu Pandey
Microsoft, Google, NVIDIA and HPE Certified Trainer
Director of Engineering at Meteoros Automation, ranked in Microsoft's Top 100 Trainers of 2025, holding MCT, Google Cloud, NVIDIA and PeopleCert credentials, with 500+ trainings delivered since 2011.
Sid
Anthropic Authorized Instructor and Azure Data Engineer
Dynamic corporate trainer and consultant with more than 10 years of experience across Microsoft Fabric, Azure Data Engineering, and modern cloud platforms. Focused on clear, practical learning that sticks.
Arshad Ahmad
Microsoft Certified Trainer (MCT), Cybersecurity & Power Platform Expert
Technology Trainer with 15 years in strategic client delivery, holding MCT, Azure Solutions Architect Expert, Cybersecurity Architect Expert and Power BI Data Analyst credentials, with 200+ trainings delivered.
Sravia
NVIDIA Authorized Instructor and AI Data Specialist
Passionate AI and data evangelist with over 10 years of experience across machine learning, MLOps, and cloud native technologies. Dedicated to delivering impactful, engaging enterprise training programs.
Johan
Microsoft Business Applications MVP and Microsoft Certified Trainer
D365 Customer Service Lead – Europe at Avanade, and founder of the Power Platform School. A Microsoft Business Applications MVP and Microsoft Certified Trainer based in London, specializing in Dynamics 365 Customer Service and Power Platform.
Vikas Mittal
Google and Anthropic Authorized AI Instructor
Veteran technology trainer with more than 25 years of rich industry experience spanning Google, Microsoft, and emerging AI platforms. An exceptional mentor recognized for proven teaching excellence.
Deep
Anthropic Authorized Instructor and AI Cloud Specialist
Seasoned technology leader with over 20 years of experience across AI, cloud computing, and enterprise training. Known for simplifying complex ideas and delivering practical, real world learning.
Bipeen
AWS, Microsoft, and Anthropic Certified Trainer
AI, machine learning, and cloud transformation expert with more than 25 years of experience. A renowned global corporate trainer and conference speaker known for practical, outcome driven sessions.
Akim Nyamande
Microsoft, CompTIA, Juniper and Cisco Certified Trainer
IT training facilitator with over five years of experience and certifications across Microsoft, CompTIA, Juniper, and Cisco. Previously a Network Administrator before moving into technical training, now delivering hands-on courses in networking, systems administration, and cybersecurity fundamentals.
Ali El Khatib
Cisco Certified Systems Instructor (CCSI) and Microsoft Certified Trainer
Infrastructure Engineer at RHUH with 13 years in the training field, holding CCSI, MCSE, CCNP Routing and Switching, CCNP Security, CompTIA and Microsoft Azure certifications.
Florian Garcia Compte
Cisco Certified Systems Instructor (CCSI)
Partner Director at AVAANZA FORMACION, a Cisco Learning Partner based in Madrid. Certified Cisco Systems Instructor (CCSI No. 21053) specializing in Cisco Data Center (ACI/SDN), Nexus, and Wireless, delivering official Cisco certification courses including CCNA, CCNP Enterprise, and CCNP Data Center.
Data Analyst Job-Oriented Program — PL-300
The 360DT Data Analyst Job-Oriented Program takes you across the full PL-300 blueprint — Power Query, semantic modelling, DAX, reporting, and Power BI governance — then past it into portfolio projects and interview preparation. You finish exam ready for PL-300 and holding the 360DT AI Powered Analyst badge, verified on Credly.
Explore the Data Analyst Program
PL-300 frequently asked questions
Is PL-300 still worth it in 2026?
Yes, and arguably more than before. It is the most name-recognised analytics credential Microsoft issues, it appears by exam code in job adverts, and the April 2026 refresh added DirectLake and Copilot objectives so it now certifies the current product rather than an older version of it.
What is the hardest part of the PL-300 exam?
Modelling and DAX — specifically CALCULATE and filter context, relationship cardinality and cross-filter direction, and time intelligence. Three of the four domains carry an identical 25–30% weight, so candidates who are strong on visuals and weak on modelling lose more marks than they expect.
How much DAX do I need for PL-300?
More than most people arrive with. The blueprint states you should be proficient at Power Query and DAX, and it names single aggregation measures, CALCULATE, time intelligence, statistical functions, semi-additive measures, quick measures, calculated tables and columns, and calculation groups. Visual calculations in DAX appear separately in the reporting domain.
Does PL-300 now cover Microsoft Fabric and Copilot?
Partly, yes. “Choose between DirectLake, DirectQuery, and Import” brings a Fabric storage mode onto the exam, and four Copilot tasks are named in the reporting domain — narrative visuals, creating a report page, suggesting page content, and summarizing the semantic model. Prep material that predates 20 April 2026 will not cover these.
How long does it take to prepare for PL-300?
Around ten weeks at 6–8 hours per week for someone comfortable with Excel and reporting — the roadmap on this page. Working Power BI users can compress it, but rarely below six weeks, because DAX proficiency comes from writing measures rather than watching them being written.
Do I need programming experience for PL-300?
Not general programming, but you do need two domain-specific languages: Power Query (M, mostly through the interface) and DAX (written directly). DAX is a formula language rather than a programming language, and analysts without a coding background learn it every day — but it is real learning, not a menu you click through.
Does the PL-300 certification expire?
Yes. Microsoft associate certifications expire annually, and PL-300 is Associate tier. Renewal is free — you pass a short online assessment on Microsoft Learn during the renewal window. It is far less work than the original exam, but you do have to remember to do it.
PL-300 or DP-700 — which should I take first?
PL-300 first if you are coming from Excel, reporting or a business role: it is the presentation and modelling layer, and it is more immediately employable. DP-700 next if you want to move upstream into Microsoft Fabric data engineering, where pipelines and lakehouses live. Together they cover the pipeline from raw source to governed report, which is why our programme pairs them.
Sources and further reading
- Microsoft Learn — Study guide for Exam PL-300: Microsoft Power BI Data Analyst (audience profile, four skills-measured domains and weightings, full objective list, skills measured as of 20 April 2026, change log)
- Microsoft Learn — exam scoring and score reports (a score of 700 or greater is required to pass)
- Microsoft Learn — certification renewal (associate, expert and specialty certifications expire annually and renew via a free online assessment)
- Microsoft Learn — free official PL-300 practice assessment
- Published Indian and US data analyst, BI analyst and Power BI developer compensation ranges, used for role context only
360DT is an independent training provider. Microsoft certification exams are administered by Microsoft through Pearson VUE and are not included in programme tuition. Exam details are accurate as of 20 August 2026; always confirm current format, pricing, renewal policy and skills measured on Microsoft Learn before booking.