Updated for July 2026 Exam Objectives

PL-300 Practice Test

Microsoft Certified: Power BI Data Analyst Associate

DAX, Power Query, and governance — the questions that decide who passes PL-300.

Our questions target the scenarios that trip up even experienced Power BI users: context transition, ALLSELECTED, query folding, RLS, and deployment pipelines. 40 questions free — no account required.

Start Free Practice — 40 Questions

No credit card required. Upgrade to full 500 questions for $19.99 when ready.

500 Exam-Style Questions

91% Pass Rate

7-Day Money-Back Guarantee

Is this for you?

Your PL-300 exam is in the next 2-4 weeks

You've studied the concepts but aren't sure you'll pass

You want questions harder than the real exam

You want to understand why answers are correct, not just memorize

This is NOT for you if:

You're looking for braindumps or exam leaks

You haven't started studying the concepts yet

Most successful candidates start practice 2-3 weeks before their exam

Updated for the July 2026 exam blueprint

PL-300 Exam Details

What to expect on exam day

Questions

40-60 questions

Duration

65 minutes

Passing Score

700/1000

Exam Cost

$165 USD

Exam Domains Covered

Master all topics tested on the PL-300 exam

Prepare the data (25-30%)

Model the data (25-30%)

Visualize and analyze the data (25-30%)

Manage and secure Power BI (15-20%)

Test Yourself Right Now

Try 5 real practice questions — no signup needed

🎯

5 Free PL-300 Questions

See how ready you are for the PL-300 exam. Each question includes a detailed explanation so you learn as you go.

No account requiredTakes 2-3 minutesInstant results

Sample PL-300 Practice Questions

10 real questions from the free PL-300bank. Pick an answer in your head, then open “Show answer” for the explanation.

1. A Power Query Column Quality profile shows: Valid 94%, Error 3%, Empty 3%. What does the "Error" percentage represent?
- A. Rows where the column value does not match the column's expected data type after an explicit type conversion step
- B. Rows where the column contains null or blank values that were not replaced
- C. Rows where the current applied transformation step produced a conversion or parsing error on that column
- D. Rows excluded from the dataset by an earlier filter step that removed out-of-range values
Show answer
Correct answer: C
In Power Query Column Quality, "Error" represents rows where the current transformation pipeline produced an error for that column - for example, a failed data type conversion, division by zero, or formula error. "Empty" covers null and blank values. Valid rows have passed all transformations without error. Rows excluded by a filter step are not shown in profiling because they are no longer part of the current query result set.
2. During a Power Query refresh, an analyst receives: "DataFormat.Error: We couldn't parse the input provided as a Number value." The affected column contains mostly numeric values but some rows contain "N/A" and " - " imported from a CSV export. What is the correct resolution sequence?
- A. Change the column data type to Text to accommodate all values including the non-numeric markers
- B. Use "Remove Errors" after the Decimal Number conversion to drop rows that contain parsing failures
- C. Replace the non-numeric markers with null via Replace Values, then convert the column to Decimal Number
- D. Enable "Detect data types" so Power Query automatically determines the best type for mixed-content columns
Show answer
Correct answer: C
The error occurs because non-numeric strings cannot be coerced to Decimal Number. The fix is to first replace non-numeric markers with null (which is a valid absence of value for numeric columns), then set the column type to Decimal Number. Changing to Text loses numeric semantics needed for calculations. "Remove Errors" deletes rows rather than repairing them, causing data loss. Auto-detection typically sets the column to Text when mixed values are present, which also loses numeric semantics.
3. An analyst needs a report parameter that allows the fiscal year used in all date filters to be changed from a predefined list of approved values without modifying query code. Which Power Query parameter configuration supports this?
- A. A Decimal Number parameter with a default value set to the current calendar year integer
- B. A Date parameter with a minimum and maximum date range constraint for the fiscal period
- C. A Text or Whole Number parameter with 'List of values' type and the approved fiscal year options
- D. A conditional column that dynamically computes the current fiscal year from today's date using Date.Year
Show answer
Correct answer: C
A Power Query parameter with the "List of values" type restricts selection to a predefined set of valid options (e.g., 2023, 2024, 2025). The parameter is then referenced in query filter steps. Stakeholders or report authors can change the value from the Manage Parameters dialog without touching query code. A plain Decimal Number parameter without list constraints allows arbitrary input. A Date parameter is for date values, not fiscal year integers. A conditional column is not a parameter and cannot be changed interactively.
4. An analyst imports a products table where the Category column contains "electronics", "Electronics", and "ELECTRONICS" for the same category. Downstream DAX measures using COUNTROWS with FILTER on Category produce inflated counts. Which Power Query transformation most efficiently resolves this?
- A. Use Replace Values to manually map each casing variant to a canonical value for each known category
- B. Apply Transform > Format > Lowercase to standardize casing across the Category column in one step
- C. Add a DAX calculated column using SWITCH to normalize category values at the reporting layer
- D. Remove duplicate rows based on the Category column to reduce the redundant category entries
Show answer
Correct answer: B
Applying a text transformation such as Lowercase or Uppercase in Power Query normalizes all casing variants in a single step, resolving the inconsistency at the data preparation layer before it reaches the model. "Replace Values" requires a separate step for each known variant and breaks when new variants appear. Handling in DAX with SWITCH adds model complexity and does not fix the underlying data. Removing duplicates by Category removes legitimate product rows, not duplicate category labels.
5. After migrating a SQL Server to a new hostname, a published Power BI dataset fails refresh. The PBIX still references the old server name. What resolution also prevents recurrence if the server name changes again?
- A. Update the server name directly in the on-premises data gateway cluster configuration in Power BI service Admin portal
- B. Replace the server name with a Power Query parameter in Power BI Desktop, then update the parameter value from the semantic model's Settings in Power BI service when the server changes
- C. Delete and recreate the semantic model in Power BI service by manually typing the new server name in the data source settings
- D. In Power BI Desktop, update the hardcoded server name in the Source step and republish the dataset to the new server
Show answer
Correct answer: B
Replacing the hardcoded server name with a Power Query parameter enables updates from Power BI service (Settings → Parameters) without republishing the PBIX file - the ideal pattern for environment-specific configuration. Gateway configuration only affects the gateway's own connection settings; the dataset's source definition must also be updated. Deleting and recreating the dataset loses all configurations (refresh schedules, permissions, etc.). Switching to OLE DB does not provide a parameterized server name or prevent the same issue from recurring.

Show 5 more questions

6. An analyst prepares a Customer dimension table in Power Query. The source data has no surrogate key - only customer email addresses - which should be unique but contain 12 duplicates from data entry errors. What is the recommended approach before creating a model relationship?
- A. Investigate and resolve the 12 duplicate email addresses in Power Query before using the email column as the relationship key
- B. Use the email column as the relationship key immediately; Power BI handles duplicate dimension key values by automatically choosing the first matching record
- C. Add an Index Column in Power Query to create an arbitrary surrogate integer key and use it as the relationship key without investigating the source duplicates
- D. Merge the Customer table with itself on the email column using Inner join to automatically remove duplicate email entries
Show answer
Correct answer: A
A dimension table used on the "one" side of a one-to-many relationship must have unique key values. Duplicates in the key column cause relationship ambiguity, many-to-many relationships, or errors in Power BI. The analyst must investigate the 12 duplicates - correcting source data, merging duplicate records, or removing clearly erroneous entries - before using email as the key. Power BI does not silently ignore duplicate dimension keys. An arbitrary Index key would not represent meaningful customer identity. Self-join Inner merge does not automatically resolve which duplicate record to keep.
7. An analyst uses Column Distribution in Power Query and sees that a CustomerID column shows 5,000 "Distinct" values and 4,800 "Unique" values. What does the discrepancy indicate?
- A. 200 CustomerID values appear more than once — potential duplicate records that may need to be deduplicated
- B. 200 CustomerID values are null and need to be replaced before the column can be used as a relationship key
- C. The column contains 5,000 total rows with 4,800 non-null values and 200 null values
- D. The Distinct count exceeds the Unique count due to a data type mismatch causing comparison errors during profiling
Show answer
Correct answer: A
In Power Query Column Distribution, "Distinct" counts the total number of different values (including those that repeat), while "Unique" counts only values that appear exactly once. A Distinct count of 5,000 with a Unique count of 4,800 means 200 values appear more than once - these are duplicate CustomerID values. For a column intended to serve as a unique relationship key, this is a data quality issue that must be resolved. Nulls are shown separately in Column Quality. The discrepancy does not indicate type mismatch errors.
8. An analyst imports a table with an OrderID column (sequential integers like 10001, 10002) and a UnitPrice column (monetary values like 24.99, 150.00). Which data type assignment is most appropriate for each column?
- A. Text for OrderID and Decimal Number for UnitPrice
- B. Decimal Number for both OrderID and UnitPrice
- C. Whole Number for OrderID and Fixed Decimal Number for UnitPrice
- D. Whole Number for both OrderID and UnitPrice
Show answer
Correct answer: C
OrderID contains integer identifiers, making Whole Number the appropriate type. UnitPrice contains monetary values with decimals; Fixed Decimal Number (the Currency type in Power Query) uses fixed-point arithmetic that avoids floating-point rounding errors common in financial calculations - it is the preferred type for monetary values. Text is inappropriate for an integer used in relationships. Using Decimal Number for OrderID is technically functional but semantically incorrect. Whole Number for UnitPrice would truncate decimal values.
9. An analyst needs to relate a Sales fact table (Sales[ProductCode]) to a Product dimension table (Product[Code]) in a Power BI semantic model. After confirming column values match, what is the recommended approach?
- A. Define a model relationship between Sales[ProductCode] and Product[Code] in Power BI Desktop's Model view
- B. Merge the Sales table with the Product table in Power Query using a Left Outer join on ProductCode = Code to denormalize
- C. Replace ProductCode in Sales with an auto-incremented Index column as a surrogate key before defining any relationship
- D. Duplicate the Product table and embed its columns inside the Sales query to avoid cross-table relationship management
Show answer
Correct answer: A
Defining a relationship in Model view between Sales[ProductCode] and Product[Code] is the correct approach for connecting tables in a star schema. Power BI's relationship engine (VertiPaq/DirectQuery optimizations) handles filter propagation efficiently. Merging tables in Power Query for relationship purposes creates a denormalized flat table that prevents the native relationship engine from operating. Surrogate keys improve performance but are an optimization, not a requirement for defining relationships. Embedding dimension data inside fact queries produces a flat schema that degrades model performance.
10. A data analyst wants to view Column Distribution, Column Quality, and Column Profile statistics while working in Power Query Editor. Which ribbon tab contains these options?
- A. Home
- B. Transform
- C. Add Column
- D. View
Show answer
Correct answer: D
Column Distribution, Column Quality, and Column Profile are data profiling tools found on the View tab in Power Query Editor. These toggle panel options appear below the data preview, showing value distributions, null percentages, distinct counts, and error rates. They are not available on the Home, Transform, or Add Column tabs.

PL-300 study resources

Why Practice with MSCertQuiz?

Microsoft Learn teaches concepts. We prepare you for the actual exam.

Questions designed to expose common PL-300 mistakes before the real exam does

Deep DAX coverage: context transition, CALCULATE modifiers, time intelligence, and ALLSELECTED

Power Query M language, query folding, and data transformation scenarios

Updated for the latest 2026 exam objectives — DirectLake, Fabric, and governance included

Objectives last checked against Microsoft Learn: July 12, 2026

Not sure if you're ready for the PL-300 exam?

Take the free PL-300 Readiness Check →

What Our Users Say

91% pass rate — Based on users who completed at least 2 practice exams

“The DAX questions on context transition and CALCULATE were exactly what I needed. The explanations actually taught me why, not just what. Passed PL-300 with 745 on my first attempt.”

Sara P.

Scored 745 on PL-300

“Power Query M language was my weak spot. MSCertQuiz had scenarios covering query folding, error handling, and combining files that I hadn't seen anywhere else. The difficulty level is spot on.”

Mike K.

PL-300 Certified

“I've been using Power BI for 3 years but still found the governance and security questions challenging. MSCertQuiz RLS, deployment pipeline, and gateway scenarios prepared me for what actually appeared on the exam.”

Tanya C.

Passed PL-300 first try

Choose Your Plan

Start free, upgrade when you're ready to get serious

Free

Good for exploring the platform

40 practice questions
Practice mode only
Progress tracking
No exam simulation mode

Start Free

PL-300 Full Access

Best if your exam is in the next 2-4 weeks

$19.99one-time

500 practice questions
Practice & Exam modes
Detailed explanations
Lifetime access

Get PL-300 Access — $19.99

7-day money-back guarantee

BEST VALUE

Pro — All Certs

Best if you're planning multiple Microsoft exams

$14.99/month

ALL certifications included
Unlimited questions
New certs added free
Cancel anytime

View Pro Plans

Save 30% vs buying individually

Your PL-300Exam Won't Wait

Candidates who complete at least 2 full mock exams pass at significantly higher rates than those who only study passively.

Don't risk $165 USD on the real exam without testing yourself first.

Start Free Practice Now

No credit card required • 40 free questions • Upgrade for $19.99 when ready

Official Microsoft Resources

Our practice questions are aligned with official Microsoft exam objectives. We recommend studying with Microsoft Learn first, then using MSCertQuiz to test your readiness.

View Official PL-300 Exam Details

PL-300 Frequently Asked Questions

Everything you need to know about the PL-300 Microsoft Power BI Data Analyst certification

How hard is the PL-300 exam?

The PL-300 is considered a moderately challenging Associate-level exam. DAX is the most complex area — especially context transition, CALCULATE modifiers, and time intelligence. Power Query M language and data modeling concepts (star schema, relationship cardinality, cross-filter direction) are also tested deeply. Most candidates with hands-on Power BI experience pass within 2–3 attempts. Strong DAX knowledge is the key differentiator.

Is PL-300 worth it in 2026?

Yes. Power BI is the dominant self-service BI tool at Microsoft organizations, and PL-300 is the only Microsoft certification that validates Power BI skills specifically. Data analyst and BI developer roles frequently list PL-300 as preferred or required. It is also the gateway to Microsoft Fabric certifications (DP-600) for candidates moving into data engineering and analytics engineering roles.

What is the passing score for PL-300?

The PL-300 passing score is 700 out of 1000. Microsoft does not publish an exact question count, and the time limit is 100 minutes. Microsoft uses scaled scoring, so not all questions are worth the same points. Case studies and drag-and-drop questions can carry higher weight than standard multiple-choice.

How long should I study for PL-300?

Most successful candidates spend 6-10 weeks preparing. We recommend hands-on Power BI Desktop and Power BI Service experience alongside our practice questions. DAX requires practical understanding — you need to build measures and see context transition in action, not just read about it. Candidates who complete at least 2 full timed practice rounds score significantly higher than those who only study passively.

What score do I need to pass PL-300?

You need 700 out of 1000 to pass. Microsoft uses scaled scoring, so it is not a simple 70%. Some question types (case studies, drag-and-drop) carry more weight. Our practice tests help you consistently score above 80% so you have a comfortable margin on exam day.

How is MSCertQuiz different from free PL-300 practice tests?

Free practice tests typically cover basic DAX syntax and simple report concepts. MSCertQuiz offers 357 scenario-based PL-300 questions with detailed explanations covering complex DAX patterns (ALLSELECTED, KEEPFILTERS, context transition), Power Query M syntax, composite models, DirectLake, and Power BI governance. Our questions are designed at Associate exam difficulty, not just definition recall.

What topics does PL-300 cover?

PL-300 covers four domains: Prepare the data (25-30%) — Power Query transformations, M language, data source connections, query folding. Model the data (25-30%) — star schema design, DAX measures, relationships, time intelligence, optimization. Visualize and analyze the data (25-30%) — report design, visuals, bookmarks, drill-through, AI features. Manage and secure Power BI (15-20%) — workspaces, row-level security, gateways, deployment pipelines, licensing, sensitivity labels.

How many questions are on the PL-300 exam?

Microsoft does not publish the exact number of PL-300 questions in advance, and it varies per attempt. Question types include multiple choice, drag-and-drop, case studies, and build-list questions. You have 100 minutes to complete the exam.

How long is the PL-300 exam?

The PL-300 exam is 100 minutes long, so time management is important. Practicing under timed conditions (as our exam mode simulates) ensures you are comfortable with the pace on test day — especially for DAX questions that require careful reading.

How much does the PL-300 exam cost?

The PL-300 exam costs $165 USD. Pricing may vary by country due to Microsoft's market-based pricing. Microsoft occasionally offers discounted or free vouchers through events like Microsoft Ignite or ESI programs for employees of Microsoft partners. Check Microsoft Learn for current pricing in your region.

How long is the PL-300 certification valid?

PL-300 is an Associate-level certification and requires annual renewal. Microsoft sends renewal reminders 6 months before expiry. Renewal is free and done online via Microsoft Learn with a shorter assessment — no need to retake the full exam. Staying current ensures your certification reflects the latest Power BI and Fabric capabilities.

What is the difference between PL-300 and DP-600?

PL-300 (Power BI Data Analyst) focuses on self-service analytics: Power Query, DAX, report design, and Power BI Service governance. DP-600 (Microsoft Fabric Analytics Engineer) focuses on the data engineering side: lakehouses, data pipelines, Spark notebooks, semantic models, and Fabric architecture. PL-300 is the right starting point for analysts and report builders. DP-600 is for those moving into data engineering or Fabric administration roles. Both are $165 and require annual renewal.

What changed in the PL-300 exam in 2026?

Microsoft updated PL-300 objectives in 2024-2025 to include Microsoft Fabric integration, DirectLake mode, and Copilot in Power BI features. The four-domain structure remains the same but questions now reflect Fabric workspace concepts, OneLake connectivity, and semantic model management in Fabric. Our question bank is updated for the current 2026 exam blueprint.

What are the PL-300 exam topics for 2026?

PL-300 covers four domains for 2026. (1) Prepare the data (25-30%): connect to data sources, profile and clean data, Power Query transformations, M language, query folding, combining queries. (2) Model the data (25-30%): star schema design, DAX measures and calculated columns, relationships, time intelligence, performance optimization. (3) Visualize and analyze the data (25-30%): report design, visuals, conditional formatting, bookmarks, drill-through, Q&A, AI visuals, anomaly detection. (4) Manage and secure Power BI (15-20%): workspaces, row-level security, gateways, deployment pipelines, licensing, sensitivity labels, endorsement.

What is the PL-300 passing score in 2026?

The PL-300 passing score is 700 out of 1000 in 2026. This has been stable for several years. Microsoft uses scaled scoring rather than raw percentage, so the exact number of correct answers required varies depending on question difficulty. Consistently scoring 80%+ on realistic practice tests gives you a comfortable margin on exam day.

PL-300 Exam Cost 2026

The PL-300 exam costs $165 USD in 2026 — the standard Microsoft Associate-level certification price. Pricing varies by country: approximately ₹4,800 INR in India, £113 GBP in the UK, and roughly €165 EUR in most European markets. Always confirm the current price on the official Microsoft Learn scheduling page for your region.

There are no formal prerequisites. Microsoft recommends hands-on Power BI experience and familiarity with data modeling concepts before attempting the exam. PL-300 expires annually — renewal is free via a shorter online assessment on Microsoft Learn. Microsoft Ignite, Enterprise Skills Initiative (ESI), and Microsoft Learn Cloud Skills Challenges occasionally offer free or discounted exam vouchers.

PL-300 vs DP-600: Power BI vs Fabric Analytics Engineer

PL-300 and DP-600 are the two main Microsoft data certifications for analytics professionals — but they target different roles and skill depths. PL-300 is Power BI–focused; DP-600 is the Microsoft Fabric Analytics Engineer certification covering the full Fabric platform.

	PL-300	DP-600
Role	Power BI Data Analyst	Microsoft Fabric Analytics Engineer
Platform	Power BI (reports, dashboards, DAX)	Microsoft Fabric (Lakehouse, Warehouse, Pipelines, Real-Time Analytics)
Level	Associate	Associate
Cost	$165 USD	$165 USD
DAX required?	Yes — deeply	Moderate
SQL / Spark?	Helpful but not tested heavily	Yes — T-SQL, PySpark, notebooks
Salary (US)	$80K–$125K	$95K–$145K
Best for	Business analysts, BI developers, report authors	Data engineers, analytics engineers, Fabric architects

Take PL-300 if your work centers on Power BI report building, DAX modeling, and delivering insights to business users. Take DP-600 if your role involves building data pipelines, lakehouses, and the broader Microsoft Fabric data estate. Many analytics engineers earn both — PL-300 proves reporting depth, DP-600 proves engineering breadth.

PL-300 vs PL-900: Associate vs Fundamentals

PL-900 (Power Platform Fundamentals, $99) covers awareness-level concepts across Power BI, Power Apps, Power Automate, and Power Virtual Agents. PL-300 (Power BI Data Analyst, $165) goes much deeper on Power BI specifically — advanced data modeling, complex DAX, row-level security, workspace governance, and deployment pipelines. PL-900 is the right starting point if you're new to the Power Platform. PL-300 is for practitioners who work in Power BI regularly and want to validate their professional skills. You do not need PL-900 to sit PL-300, though the fundamentals knowledge helps with understanding context.

PL-300 Salary and Career Outlook (2026)

Power BI Data Analysts with PL-300 certification in the US report the following salary ranges in 2026:

• Entry-level Power BI analyst (0–2 yrs): $60,000–$80,000 USD
• Power BI Data Analyst (2–5 yrs): $80,000–$110,000 USD
• Senior BI Developer / BI Architect: $110,000–$140,000 USD
• PL-300 + DP-600 (Fabric + Power BI): $120,000–$155,000 USD
• PL-300 + DP-900 + Azure (Full Analytics Stack): $125,000–$160,000 USD

PL-300 is particularly valuable in organizations that have standardized on Microsoft 365 and Power BI for their analytics stack. As Microsoft Fabric adoption grows in 2026, Power BI skills remain foundational — Fabric's Power BI experience is built on the same semantic model and DAX engine. Analysts who can bridge business reporting (PL-300) and data engineering (DP-600) are increasingly sought after.

PL-300 Exam Topics 2026: Domain Breakdown

PL-300 covers four domains. Microsoft periodically refines question weighting — always verify the latest exam objectives on the official Microsoft Learn PL-300 page before your exam date.

Prepare the Data

25–30%

Connect to data sources (files, databases, cloud services, SharePoint, APIs), shape and transform data in Power Query, handle data type conversions and errors, combine queries (merge, append), implement incremental refresh, profile data quality, configure query parameters and templates.

Model the Data

25–30%

Design and implement star schemas, configure relationships (cardinality, cross-filter direction), create calculated columns and measures using DAX, use time intelligence functions (DATEADD, TOTALYTD, SAMEPERIODLASTYEAR), implement row-level security (RLS) and object-level security, optimize data models for performance.

Visualize and Analyze the Data

25–30%

Create reports with appropriate visuals (bar, line, map, matrix, KPI, decomposition tree), configure interactions and cross-filtering, use slicers and filters effectively, implement bookmarks and navigation, use AI visuals (Key Influencers, Q&A, Smart Narrative), create paginated reports, design for accessibility and mobile.

Deploy and Maintain Assets

15–20%

Manage Power BI workspaces and access roles (Admin, Member, Contributor, Viewer), configure scheduled data refresh and gateway connections, publish reports and create dashboards, manage deployment pipelines (Dev/Test/Prod), configure sensitivity labels and data protection, monitor report usage and performance with usage metrics.

PL-300 Study Plan: 6-Week Schedule

Most candidates pass PL-300 in 4–8 weeks depending on their Power BI experience. This 6-week plan assumes you use Power BI regularly but want to fill gaps and pass with confidence:

Week 1: Data preparation and Power Query — connect to at least 5 different data sources, practice transformations (pivot, unpivot, merge, append), and understand query folding. Build a sample data model from scratch using public datasets.
Week 2–3: Data modeling and DAX — design a star schema, implement relationships correctly, and write 20+ DAX measures covering aggregations, filters (CALCULATE, FILTER, ALL, ALLEXCEPT), and time intelligence (YTD, MTD, SAMEPERIODLASTYEAR, DATEADD). DAX is the hardest part of PL-300 — invest the most time here.
Week 4: Visualization and report design — build a complete multi-page report using 10+ visual types, configure cross-filtering, implement bookmarks and navigation buttons, and use AI visuals. Practice mobile layout view and accessibility features.
Week 5: Security, deployment, and workspace management — configure RLS roles and test them, set up scheduled refresh with an on-premises gateway, publish to workspaces, configure deployment pipelines, and review sensitivity label configuration.
Week 6: Take 40 free practice questions to identify weak areas. Re-study the lowest-scoring domain. Run two full timed mock exams — aim for 80%+ consistently before booking. Focus on DAX scenario questions which are the most common exam stumbling block.

Training your whole team on PL-300? Per-seat pricing covers every certification, with a manager dashboard to see who's exam-ready.

See team pricing →