Azure Mastery

Microsoft Certification PL-300

PL-300: Predict your score. Know what to study next.

See your predicted score, follow a study plan based on your answers, and revisit topics you're starting to forget. It all runs on your device.

398 practice questions AI score prediction 100% offline
Download free iPhone & iPad · Free to start QR code — scan with your iPhone to open Azure Mastery on the App Store On your Mac?
Scan to install

PL-300 Practice Questions & Exam Prep — Microsoft Power BI Data Analyst

Get exam-ready for PL-300 (Microsoft Power BI Data Analyst) on iPhone or iPad. Azure Mastery uses on-device AI to predict your readiness score across all four PL-300 domains, build a personalised study plan from your weak spots, and surface topics you're forgetting. Core study stays on-device and works offline; optional sync uses your private iCloud account.

The exam

What is the PL-300 exam?

PL-300 is the Microsoft Certified: Power BI Data Analyst Associate exam — the credential hiring managers expect for "Power BI Developer" or "Data Analyst" roles. It validates that you can deliver actionable insights end-to-end with Power BI, from cleaning raw data through to governed dashboards. PL-300 pairs naturally with DP-900 on the analyst track.

PL-300 is hands-on and tool-aware: expect scenario questions that show a Power Query step or a DAX measure and ask you to predict the result. Across the outline, you'll cover:

Microsoft updated the PL-300 skills outline on 20 April 2026. Every question in Azure Mastery's PL-300 bank is mapped to the current outline — no leftover questions on retired features. Read the official outline at learn.microsoft.com.

Skills measured · 20 April 2026

PL-300 exam objectives

Four domains, with weights set by Microsoft's 20 April 2026 update. Every domain below lists Microsoft's own skill groups verbatim, straight from the official skills outline, so you know exactly which domain a bullet belongs to and where the gaps sit.

Aura presents a visual map of connected business data, automation, low-code apps, and analytics skills.
Business solutions skill map

Prepare the dataPublished weight 25–30%

100 exam-scoped practice questions in the app

Explore Prepare topics
  • Get or connect to data
  • Profile and clean the data
  • Transform and load the data
  • Tests choosing Import, DirectQuery, or DirectLake and building clean fact and dimension tables in Power Query.
  • Candidates use Duplicate when a query needs to stay linked to its source through Reference instead.
  • Trace a chained query back to its source before choosing Reference or Duplicate on that step.

Model the dataPublished weight 25–30%

101 exam-scoped practice questions in the app

Explore Model topics
  • Design and implement a data model
  • Create model calculations by using DAX
  • Optimize model performance
  • Filter context, time intelligence, and picking a calculated column against a measure are what this domain checks.
  • A calculated column gets reached for even when the scenario needs a measure evaluated at query time instead.
  • Ask whether the value should be fixed per row or recalculated for whatever the visual filters.

Visualize and analyze the dataPublished weight 25–30%

118 exam-scoped practice questions in the app

Explore Visualize topics
  • Create reports
  • Enhance reports for usability and storytelling
  • Identify patterns and trends
  • Tests picking the right visual, navigation feature, or AI visual for a described reporting need.
  • Candidates default to a familiar chart type even when the scenario calls for a different visual.
  • Match the described trend, outlier, or driver to the AI visual built for that specific job.

Manage and secure Power BIPublished weight 15–20%

79 exam-scoped practice questions in the app

Explore Manage topics
  • Create and manage workspaces and assets
  • Secure and govern Power BI items
  • Workspace roles, deployment pipelines, and choosing row-level versus object-level security correctly are the focus here.
  • Under-revision here leaves row-level and object-level security tangled together in governance scenarios.
  • Remember row-level security filters rows, while object-level security hides a whole table or column.

Common traps

Where PL-300 candidates slip

Four recurring misconceptions that trip up otherwise well-prepared PL-300 candidates, grounded in the current skills outline.

Reference and Duplicate look identical, but only one keeps a live link

Both queries start from an existing one, but only Reference stays linked to its source step as that step changes.

  • Reference depends on the source query; Duplicate copies its current steps and then evolves independently. Both can still refresh their data.
  • Trace whether the scenario needs several queries to update together before choosing Reference over Duplicate.

DirectQuery changes what a measure can and can't do

Switching a table to DirectQuery changes which DAX patterns work and how a calculated column behaves at query time.

  • The exam is testing whether you know DirectQuery changes what a calculated column can do, beyond changing speed.
  • Check the storage mode named in the scenario before assuming a calculated column behaves as it would in Import.

A measure and a calculated column don't share the same context

A calculated column is fixed per row at refresh, while a measure recalculates in whatever filter context a visual applies.

  • The exam is testing whether you can tell row context apart from filter context in a DAX scenario.
  • Pick a measure whenever the value should react to slicers, filters, or the current visual.

Object-level security is not the same control as row-level security

Row-level security filters which rows a user sees, while object-level security hides an entire table or column outright.

  • The exam is testing whether you'd pick object-level security specifically to hide a whole column, the stronger control than row filtering.
  • Reach for object-level security whenever the scenario says hide a column or table completely, not restrict rows.

Designed for PL-300

How Azure Mastery helps you pass PL-300

Exam-specific practice

  • 398 PL-300 practice questions, mapped to the 20 April 2026 outline across all four domains.
  • Coverage follows Prepare, Model, Visualize, and Manage and secure, tagged so weak spots surface fast.
  • Questions rehearse predicting a DAX result or a Power Query step, the exam's actual scenario style.

Predicted score

  • Exam IQ predicts your PL-300 score on-device after roughly 30 questions, with a confidence range attached.
  • Three domains are each worth close to a quarter of the exam, so a shaky one shows up fast.
  • See exactly which domain, Power Query, DAX, visuals, or governance, needs more work before you book.

Adaptive study plan

  • Miss a DAX filter-context question and a similar scenario returns in your next session.
  • Hold a topic steady across three sessions and the plan moves on to the next weak spot.
  • Sessions chase the gap to a 700 pass score rather than piling on random volume.

Knowledge decay

  • PL-300 spans four skill areas, so DAX mastered early fades fastest if you stop revising it.
  • A padlock icon flags a topic nearing decay before exam day catches you out.
  • Focus Weak Spots sessions target whichever domain has faded most since you last practised it.

Exam rehearsal

  • Practise a full 100-minute session with flag-and-review switched off, matching the real associate-tier clock.
  • The question mix follows the domain weights from the 20 April 2026 outline.
  • Every rehearsal question is original, built to the outline rather than copied from Microsoft's paper.

Answer Coach

  • Names the exact DAX or Power Query mix-up behind a missed answer.
  • Explains why a calculated column was the wrong tool where a measure was needed, plus the rule for next time.
  • A capable device may rephrase a note on-device, but only after checking it against the written answer.

Aura guidance

  • Aura shifts focus toward modelling or visuals as your first week of PL-300 sessions plays out.
  • Get a short recap after each session naming what improved and where to go next.

Private by design

  • Your PL-300 answer history, readiness gauge, and Answer Coach notes never leave your device by default.
  • Handling other people's data for a living is exactly why nothing here needs an account or a server.
  • iCloud sync is opt-in, stays private, and never becomes a requirement to keep practising.

6-week study plan

Suggested PL-300 study plan

Build from data preparation and modelling to reports, performance and security. Follow these six weeks of study blocks, finishing with focused review and rehearsal.

  1. Connect to data

    • Explore SQL Server, Excel, Fabric and OData sources.
    • Compare Direct Lake, DirectQuery and Import.
    • Review parameters and Power Query Editor.
  2. Transform with Power Query

    • Profile columns and manage data types.
    • Practise splitting, merging and pivoting.
    • Convert JSON or XML and build fact and dimension tables.
  3. Query design

    • Compare reference and duplicate queries.
    • Practise merge and append.
    • Review Formula.Firewall and query folding.
  4. Models and DAX

    • Design star schemas, relationships and role-playing dimensions.
    • Compare calculated columns with measures.
    • Practise time intelligence and USERELATIONSHIP.
  5. Choose visuals

    • Match chart and map types to reporting needs.
    • Review KPIs, gauges and treemaps.
    • Compare decomposition trees and key influencers.
  6. Report interaction

    • Configure drill-through, drill-down and bookmarks.
    • Build tooltip pages and synced slicers.
    • Review filters and what-if parameters.
  7. Accessible report design

    • Explore AI visuals, Q&A and Smart Narrative.
    • Use custom format strings, conditional formatting and themes.
    • Review accessibility choices.
  8. Reports and performance

    • Compare paginated and Power BI reports.
    • Design mobile layouts.
    • Use Performance Analyzer and DAX Studio to investigate slow models and visuals.
  9. Publish and manage

    • Compare workspace roles, apps and direct sharing.
    • Review deployment pipelines.
    • Configure gateways and refresh.
  10. Secure the data

    • Compare static and dynamic row-level security.
    • Review object-level security and sensitivity labels.
    • Explore Purview integration and tenant settings.
  11. Target weaker topics

    • Run Focus Weak Spots sessions.
    • Balance revision across the domains.
    • Revisit missed scenarios and explanations.
  12. Timed rehearsal

    • Complete two 100-minute Exam Simulator sessions.
    • Review each run carefully.
    • Plan further study based on recurring mistakes.

Inside the app

Nine interactive practice formats, on iPhone

Azure Mastery has nine interactive formats for exam practice. The examples below show original PL-300 practice questions in Azure Mastery on iPhone and iPad. The exam simulator uses timed sessions with the published domain weights. Microsoft's live interface and question mix may differ.

Which DAX function introduces row context when iterating a table?

  • SUMX
  • SUM
  • CALCULATE
  • VALUES
  • RELATED

Multiple choice

An original PL-300 practice question with one correct answer. The app explains every option after you answer.

Exam-specific sample

Which two DAX functions return a measure of central tendency? Select two answers.

  • AVERAGE
  • MEDIAN
  • COUNTROWS
  • MAX
  • STDEV.P

Multi-select

An original PL-300 multi-select question. Select all the correct options to earn the mark.

All-or-nothing

Drag-and-drop

An original PL-300 ordering question you can answer by touch on iPhone and iPad.

Interactive item

Hotspot

An original PL-300 question with a visual prompt, designed for touch on iPhone and iPad.

Tap target

Case studies

An original PL-300 case study with several questions about the same requirements and environment.

Multi-question

Answer Coach

Answer Coach explains why the answer is correct and, where available, why each option is right or wrong. It helps you understand a mistake and remember the distinction. Read explanations after each question or at the end of a practice test. On supported devices, optional AI can reword a note on your device after checking it against the written guidance.

App exclusive

Frequently asked

PL-300 FAQs

PL-300 vs DP-900 — which should I take first?

Take DP-900 first if relational vs non-relational data, transactional vs analytical workloads, or Azure's SQL family aren't familiar yet. PL-300 assumes you already know the difference when it asks about DirectLake vs DirectQuery vs Import or Fabric semantic models. Skip DP-900 if you already do analyst work day-to-day.

PL-300 vs DP-300 — different roles?

Different angles on the data stack. PL-300 is the analyst-side cert: Power Query M, DAX, visualisations, governance and sharing. DP-300 is the operational DBA cert: HA/DR, performance tuning, security, and automation for Azure SQL. Larger teams often split the two roles.

Are there formal prerequisites for PL-300?

No mandatory prior exam, but Microsoft's audience profile expects proficiency with Power Query and DAX, plus comfort working with stakeholders on requirements and with data engineers on sourcing. Candidates without hands-on Power BI experience usually need a longer run-up, even though nothing blocks booking directly.

What's the PL-300 exam format like?

PL-300 sits in Microsoft's 40–60 question Associate band, with formats varying by sitting. Azure Mastery's bank weights single-answer and dropdown-select items heaviest, reflecting how often the exam asks you to predict a DAX result or Power Query step, alongside multi-select, drag-to-match, and case-study questions.

Does PL-300 prep need a live internet connection?

No. Every part of PL-300 practice, including the Exam IQ prediction, runs on your device rather than a server, so full sessions work on a delayed train or a long-haul flight. No account is needed, and data stays put unless you opt into private iCloud sync.

Can I test-drive Azure Mastery's PL-300 content for free?

Yes. The app is free to download, with a free allowance of PL-300 questions so you can try every feature. The full bank of 398 PL-300 practice questions unlocks with a one-time exam-pack purchase, or unlock every exam with a subscription or lifetime upgrade.

If I don't pass PL-300, when can I try again?

Not immediately, and each attempt needs its own voucher.

  • First retake: after 24 hours.
  • Second and third retakes: a 14-day wait each.
  • Cap: five attempts per rolling 12 months.
Will my PL-300 badge lapse if I don't renew?

Yes. Associate certifications including PL-300 expire annually. Renewal is a free, short online assessment on Microsoft Learn within six months of your expiry date. Fundamentals certs like AZ-900 are different — those never expire.

What's the going rate for a PL-300 exam attempt?

The PL-300 voucher is USD $165 in the US, or around £128 in the UK — pricing varies by region. Microsoft occasionally runs free-voucher promotions around events like Build or Ignite, so check your Learn profile first.

Free study guides

Free guides that pair with PL-300

Where PL-300 fits

Certification paths that include PL-300

PL-300 is the Power BI Data Analyst Associate cert. It pairs with DP-900 as the recommended fundamentals, and is the only Microsoft Associate cert dedicated to Power BI. Tap any linked exam below to see its dedicated study app page.

Ready to pass PL-300?

Download Azure Mastery free. 398 PL-300 practice questions across all four domains, AI score prediction, full-length exam simulator, adaptive study plan. iPhone & iPad.

Download Azure Mastery — free iPhone & iPad · Free to start · No account required
PL-300 practice — free on the App Store Download