Exam PL-300 leads to the Microsoft Certified: Power BI Data Analyst Associate, the standard way to show employers you can use Power BI professionally. It is a 100-minute intermediate exam with a passing score of 700, and it is renewed free every year through an online assessment on Microsoft Learn.

If you already work comfortably in Excel, six weeks of steady study is a realistic target. The skills outline was last updated on 20 April 2026 and now includes Copilot features, so make sure your course reflects that version.

Exam facts

ItemDetail
ExamPL-300: Microsoft Power BI Data Analyst
LevelIntermediate
Duration100 minutes; may include interactive components
Passing score700 or higher
LanguagesEnglish plus nine others, including Japanese, Chinese, Korean, German, French and Spanish
RetakeAllowed 24 hours after a first failed attempt; later waiting periods vary
RenewalEvery 12 months, free, through an online assessment on Microsoft Learn
FeeCountry-based pricing; check the India price shown at checkout
Free practiceOfficial practice assessment and exam sandbox on Microsoft Learn

Skills measured and what they really mean

Skill areaWeightKey topics
Prepare the data25–30%Connect to sources, choose Import, DirectQuery or Direct Lake, profile and clean data in Power Query, merge and append queries, build fact and dimension tables
Model the data25–30%Relationships and cross-filter direction, date tables, role-playing dimensions, DAX measures with CALCULATE, time intelligence, calculation groups, Performance Analyzer
Visualise and analyse the data25–30%Visuals and themes, bookmarks and drillthrough, visual calculations, Copilot report pages and narratives, forecasting and anomaly detection
Manage and secure Power BI15–20%Workspaces and apps, scheduled refresh and gateways, subscriptions and alerts, row-level security, sensitivity labels

Three topics deserve attention because older courses often skip them: choosing between Import, DirectQuery and Direct Lake storage modes; using Copilot to create report pages and summarise a semantic model; and finding slow measures with Performance Analyzer and DAX query view. The April 2026 update made minor changes to connecting to data, report usability features and workspace management, but did not change the overall weightings.

Who should take it

  • Data analysts and MIS executives who build recurring reports
  • Finance, sales and operations professionals moving into analytics
  • Freshers targeting data analyst roles who want proof of a specific tool
  • Consultants delivering reporting projects for clients

It suits people less well if their employer uses only Tableau or Looker, or if they want a data engineering role; in that case the Fabric certifications described below are a better target.

A six-week study plan

WeekFocus
1Power BI Desktop basics; connecting to Excel, CSV and SQL sources; storage modes
2Power Query: profiling, cleaning, merging, appending, unpivoting and shaping data
3Data modelling: star schema, relationships, date tables, role-playing dimensions
4DAX: CALCULATE, filter context, time intelligence, calculation groups, visual calculations
5Reports and the Power BI Service: bookmarks, drillthrough, Copilot, workspaces, apps, refresh, row-level security
6Official practice assessment, weak areas, Performance Analyzer, one complete portfolio report

Power BI Desktop is a free download but runs only on Windows, so Mac users need a Windows machine or virtual machine for practice.

Getting DAX filter context right: a worked example

DAX is where most candidates struggle, because the same measure returns different results depending on where it sits in a report. Suppose a retail model has a Sales table and a Store table. Start with a base measure:

Total Sales = SUM(Sales[Amount])

Now a measure that always shows Delhi’s sales, whatever city is selected in a slicer:

Delhi Sales = CALCULATE([Total Sales], Store[City] = "Delhi")

And Delhi’s share of the total:

Delhi Share = DIVIDE([Delhi Sales], [Total Sales])

As an illustration, if total sales in the current filter are ₹50 lakh and Delhi accounts for ₹12 lakh, Delhi Share shows 24%. Put the measure in a table by month and it recalculates for each month, because the month on each row adds to the filter context. CALCULATE replaces the city filter but keeps the month filter. Expect exam questions built on exactly this behaviour, and use DIVIDE rather than the “/” operator so that a zero total returns a blank instead of an error.

Build a portfolio report

Pick a public Indian dataset, for example from the Open Government Data Platform (data.gov.in), and build a polished report. Clean the data in Power Query, model it as a star schema, add a handful of useful measures, and design separate pages for a manager and an analyst. Publish screenshots and a short write-up on LinkedIn or GitHub explaining your modelling choices.

A good portfolio report often impresses interviewers more than the certificate itself. Our list of data analyst portfolio projects that get interviews in India has more ideas.

Common mistakes

  • Memorising DAX formulas instead of understanding filter context and context transition.
  • Under-preparing the Power BI Service. Manage and secure is worth up to 20%, and questions on workspace roles, apps, gateways and row-level security are easy marks if you have practised them.
  • Using pre-2026 material that leaves out Copilot, visual calculations and Direct Lake.
  • Skipping the free practice assessment. It is the closest guide to the question style, and it costs nothing.
  • Letting the certification lapse. Note the expiry date on your Microsoft Learn profile; the renewal assessment is free and taken online.

Next steps after PL-300

Power BI is now part of Microsoft Fabric, and Microsoft’s two Fabric associate certifications are the natural next step. The Fabric Analytics Engineer Associate (DP-600) suits analysts who want to own semantic models and lakehouses; see our DP-600 guide. The Fabric Data Engineer Associate (DP-700) suits those moving towards pipelines and data engineering. Microsoft says the English versions of both exams will be updated on 19 October 2026, so check the study guides for changes before booking.

If you are weighing a paid course for Power BI, our guide to whether a Power BI or Tableau course is worth it compares the options.

FAQ

Do I need a paid Power BI licence to prepare?

Not for most of the syllabus. Power BI Desktop is free, and Microsoft Learn’s free modules follow the exam syllabus. Practising sharing and workspace features in the Power BI Service is easier with access through an employer or a trial.

Is PL-300 enough to get a data analyst job?

Rarely on its own. Employers usually also test SQL and Excel, and they want to see a report you built. Treat the certification as proof of tool knowledge, not as a substitute for a portfolio.

Sources

Last reviewed: 8 October 2026.

Leave a Reply

Trending