Download free
iPhone & iPad · Free to startOn your Mac? Scan to install
PL-300Microsoft Power BI Data Analyst
PL-300 · 30 days left ›
PREDICTED786 ±37✓ Exam Ready · 87% confidence
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?
SUMXSUMX is a DAX iterator — it walks each row of the supplied table in row context and evaluates the expression per row. The expression reads column references against the current row.
SUMSUM aggregates a single column without iterating. It doesn't evaluate an expression per row, so it doesn't introduce row context.
CALCULATECALCULATE modifies filter context. It does perform context transition (converting an existing row context into filter context) but doesn't itself create a new row context.
VALUESVALUES returns the distinct values of a column as a single-column table. A table-valued function, not an iterator.
RELATEDRELATED uses an existing row context to navigate a relationship and pull a value from the related table. It depends on row context but does not create one.
Multiple choice
An original PL-300 practice question with one correct answer. Choose an option to read its written rationale.
Exam-specific sampleExplore more question formats
Which two DAX functions return a measure of central tendency? Select two answers.
AVERAGEAVERAGE returns the arithmetic mean of a column, a classic measure of central tendency that summarizes where values cluster.
MEDIANMEDIAN returns the middle value of the sorted set, describing the center of the distribution and resisting the influence of outliers.
COUNTROWSCOUNTROWS counts the number of rows in a table; a frequency count says nothing about where the values center.
MAXMAX returns the largest value in a column, an extreme of the distribution rather than its center.
STDEV.PSTDEV.P quantifies how far values spread around the mean, making it a measure of dispersion, not central tendency.
Multi-select
An original PL-300 multi-select question. Select all the correct options to earn the mark.
All-or-nothing
Order the steps to import an Orders table when OrderDate arrives as locale-formatted text and only 2026 rows should load.
⋮⋮1Connect to the data source and preview the Orders table
⋮⋮2Convert OrderDate to Date by using the source locale
⋮⋮3Filter OrderDate to dates in 2026
⋮⋮4Close & Apply so the filtered table loads to the model
Drag-and-drop
An original PL-300 ordering question you can answer by touch on iPhone and iPad.
Interactive item
In Power BI Desktop, from which Modeling option do you create row-level security roles and their DAX filters?
Hotspot
An original PL-300 question with a visual prompt, designed for touch on iPhone and iPad.
Tap target
Tailwind Toys — Building a sales analytics report Tailwind Toys wants a sales report over a large, frequently updated sales table joined to product and date dimensions. Regional managers should see only their own…
1Which storage mode gives the fastest, most responsive visuals when the data fits…
2How should the relationship between the sales fact table and the product…
3How should the analyst create a year-to-date sales measure?
4Which visual best shows the sales trend over time?
Case studies
An original PL-300 case study with several questions about the same requirements and environment.
Multi-question
✕Your answer: SUM
✨ Answer Coach:SUM aggregates a single column without iterating. It doesn't evaluate an expression per row, so it doesn't introduce row context.
— grounded in authored certification guidance
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
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:
Connecting to and cleaning data from heterogeneous sources with Power Query (M)
Designing a star-schema model with DAX calculations and time intelligence
Building effective visualisations — the right visual choices, drill paths, and AI visuals
Operating Power BI at scale: workspaces, deployment pipelines, gateways, refresh schedules, RLS / OLS, and Microsoft Purview sensitivity labels
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.
QuestionsTypically 40–60; formats vary
Duration100 minutes
Pass score700 / 1000
CostUSD $165 (≈ £128 UK)
ValidityRenew annually (Associate)
FormatOnline or test centre
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.
Business solutions skill mapDataAutomateBuildAnalyse
Prepare the dataPublished weight 25–30%
117 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%
114 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%
127 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%
80 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
438 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 pacing. Microsoft allows marking and review; breaks and some section transitions restrict returning to earlier questions.
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.
Connect to data
Explore SQL Server, Excel, Fabric and OData sources.
Compare Direct Lake, DirectQuery and Import.
Review parameters and Power Query Editor.
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.
Query design
Compare reference and duplicate queries.
Practise merge and append.
Review Formula.Firewall and query folding.
Models and DAX
Design star schemas, relationships and role-playing dimensions.
Compare calculated columns with measures.
Practise time intelligence and USERELATIONSHIP.
Choose visuals
Match chart and map types to reporting needs.
Review KPIs, gauges and treemaps.
Compare decomposition trees and key influencers.
Report interaction
Configure drill-through, drill-down and bookmarks.
Build tooltip pages and synced slicers.
Review filters and what-if parameters.
Accessible report design
Explore AI visuals, Q&A and Smart Narrative.
Use custom format strings, conditional formatting and themes.
Review accessibility choices.
Reports and performance
Compare paginated and Power BI reports.
Design mobile layouts.
Use Performance Analyzer and DAX Studio to investigate slow models and visuals.
Publish and manage
Compare workspace roles, apps and direct sharing.
Review deployment pipelines.
Configure gateways and refresh.
Secure the data
Compare static and dynamic row-level security.
Review object-level security and sensitivity labels.
Explore Purview integration and tenant settings.
Target weaker topics
Run Focus Weak Spots sessions.
Balance revision across the domains.
Revisit missed scenarios and explanations.
Timed rehearsal
Complete two 100-minute Exam Simulator sessions.
Review each run carefully.
Plan further study based on recurring mistakes.
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?
The app is free to download. Start with 50+ free PL-300 questions and written explanations to see how the revision flow feels. A one-time exam-pack purchase opens the full 438-question bank for Power BI practice, or you can choose Pro with a subscription or lifetime access. Exam IQ and Answer Coach are Pro benefits, separate from the Power BI bank purchase.
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.
All subsequent retakes: a 14-day wait each.
Cap: five total attempts within 12 months of the first attempt.
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.
PL-300 sits at the analyst-side Associate tier. DP-900 builds the data fundamentals it leans on; many candidates also hold DP-300 (Database Administrator) for adjacent role coverage in smaller BI teams.
Ready to pass PL-300?
Download Azure Mastery free. 438 PL-300 practice questions across all four domains, AI score prediction, full-length exam simulator, adaptive study plan. iPhone & iPad.