PL-300 Domain 1: Prepare the data (25-30%) - Complete Study Guide 2026

What Domain 1 Actually Covers

Domain 1, "Prepare the data," is one of three co-weighted domains on the PL-300 exam, each accounting for 25-30% of your final score. That places it on equal footing with Domain 2 (Model the data) and Domain 3 (Visualize and analyze the data), and noticeably heavier than Domain 4 (Manage and secure Power BI) at 15-20%. If you're mapping out your prep across all four content areas, the PL-300 Exam Domains 2026: Complete Guide to All 4 Content Areas is a useful companion to this deep dive.

In Microsoft's official skills outline (current as of April 20, 2026), Prepare the data spans everything that happens before you build a single visual: connecting to sources, shaping and profiling data, and preparing it for modeling. This is the Power Query layer of Power BI, and it demands real, hands-on fluency rather than surface-level familiarity.

Connect to and Get Data From Multiple Sources

The first cluster of skills in Domain 1 revolves around identifying and connecting to data. You need working knowledge of how Power BI Desktop handles different source types and connectivity modes, because the exam will present you with scenarios asking which connection mode or source configuration is appropriate for a given business requirement.

A subtlety many candidates miss: the exam doesn't just ask "what is DirectQuery." It asks you to read a business scenario (real-time reporting need, huge fact table, refresh limitations) and infer the correct connectivity approach. This scenario-based framing is consistent across the whole exam, and it's covered in more depth in the PL-300 Study Guide 2026: How to Pass on Your First Attempt.

Profile, Clean, and Transform Data

Once data is connected, Domain 1 shifts to data profiling and transformation - arguably the meatiest part of this domain. You're expected to evaluate data quality, identify anomalies, and apply the right Power Query transformation to fix them.

• Using the Data Profiling tools (Column quality, Column distribution, Column profile) to assess completeness and accuracy
• Identifying and resolving errors, nulls, duplicates, and inconsistent data types
• Merging and appending queries, and understanding the difference between the two
• Pivoting, unpivoting, and transposing data to reshape tables for modeling
• Splitting columns, extracting values, and using conditional columns
• Creating and applying custom functions in Power Query (M language basics)
• Managing query dependencies and understanding the applied steps sequence

How Domain 1 Questions Are Written on the Exam

PL-300 is delivered through Pearson VUE, either at a test center or online proctored, with a standard fee of USD 165 (regional pricing and student discounts may apply at checkout). The exam runs 100 minutes and typically includes 40-60 items, some grouped into case studies. Microsoft doesn't publish a fixed count of scored versus unscored questions, so you should treat every item as if it counts.

For Domain 1 specifically, expect a mix of:

• Multiple-choice questions describing a data quality problem and asking which Power Query step resolves it
• Case study questions that give you a business scenario with multiple data sources and ask you to sequence the correct preparation steps
• Interactive or drag-and-drop style items testing your ability to match transformation types to outcomes

Because passing requires a scaled score of 700 out of 1000, no single domain can be treated as optional - but Domain 1's weighting means a shaky grasp of Power Query can meaningfully drag your score down. If you're still deciding how much total prep time this exam deserves, How Hard Is the PL-300 Exam? Complete Difficulty Guide 2026 breaks down where most of the difficulty actually lives.

Power Query Skills You Must Master

If you take one thing away from this guide, it's that Domain 1 is fundamentally a Power Query exam. Microsoft's own prerequisite guidance states candidates should already be proficient with Power Query and DAX before attempting PL-300 - Domain 1 is where that Power Query proficiency gets tested most directly.

These performance-oriented concepts are easy to skip in a rushed study plan, but they show up in scenario questions where the "correct" answer depends on efficiency, not just functional correctness.

Common Mistakes Candidates Make on Domain 1

1. Treating Power Query as "just clicking buttons." The exam tests conceptual understanding of what each transformation does under the hood, not just the ability to click through the UI.
2. Skipping the M language entirely. While you won't be asked to write complex M code from memory, understanding basic M syntax helps you interpret advanced editor scenarios.
3. Ignoring data profiling tools. Column quality and distribution features are specifically named in the skills outline and appear in scenario questions.
4. Confusing merge and append. This distinction is tested repeatedly in different scenario wrappers.
5. Under-practicing with real messy datasets. Clean sample data doesn't prepare you for the kind of "find the anomaly" questions Domain 1 favors.

Where Domain 1 Fits in Your Study Schedule

Because Domain 1, Domain 2, and Domain 3 are each weighted 25-30%, none of them should be an afterthought - but Domain 1 pairs naturally with early study weeks since data preparation is the foundation everything else builds on. You can't model relationships or build meaningful visuals from data you haven't properly shaped.

This sequencing matters because Domain 2 (Model the data) is widely considered the hardest domain due to DAX and star-schema complexity - going in with clean, well-understood Power Query habits from Domain 1 removes one variable from that harder stretch. Full details on Domain 2 are covered in our dedicated PL-300 Domain 2: Model the data (25-30%) - Complete Study Guide 2026.

How Domain 1 Connects to the Other Domains

Data preparation isn't an isolated skill set on this exam - it's the input to everything else. A poorly shaped table in Domain 1 creates downstream problems in Domain 2's relationships and Domain 3's visuals. Understanding this connective thread helps you study more efficiently rather than in four disconnected silos.

• Clean, well-typed columns from Domain 1 directly enable the relationship and DAX work covered in PL-300 Domain 2: Model the data (25-30%) - Complete Study Guide 2026
• Properly shaped tables make the visualization and analytics tasks in PL-300 Domain 3: Visualize and analyze the data (25-30%) - Complete Study Guide 2026 far more straightforward
• Once your model is built and published, governance tasks from PL-300 Domain 4: Manage and secure Power BI (15-20%) - Complete Study Guide 2026 assume the underlying data was prepared correctly

If you're earlier in your research and still working out what this credential involves overall, background pieces like What Is PL-300?, PL-300 Meaning, and PL-300 Certification provide useful context before you commit to a study timeline.

Who Actually Uses These Domain 1 Skills on the Job

Data preparation skills tested in Domain 1 map directly to real job responsibilities. Employers hiring for business intelligence analyst, reporting analyst, and data analyst roles routinely list Power Query, data cleaning, and source integration as core requirements - not optional extras. If you're evaluating whether this certification is worth pursuing for your career stage, Is the PL-300 Certification Worth It? Complete ROI Analysis 2026 and PL-300 Jobs both dig into how these skills translate into hiring conversations.

Understanding compensation expectations for roles that require these skills can also help you decide how much time investment makes sense; see PL-300 Salary Guide 2026: Complete Earnings Analysis for a numbers-based view.

Registration and Retake Mechanics Worth Knowing

PL-300 is scheduled through Pearson VUE at a standard US fee of USD 165, with regional pricing and student discounts shown at checkout in many locations - there are no separate member/non-member pricing tiers. There are no formal prerequisites to register, though Microsoft explicitly recommends Power Query and DAX proficiency before attempting the exam, which reinforces just how central Domain 1's subject matter is to overall readiness. Once earned, the certification is valid for 12 months and can be renewed for free through an online assessment on Microsoft Learn during the six-month window before expiry. A full cost breakdown, including what happens if you need to retake, is available in PL-300 Certification Cost 2026: Complete Pricing Breakdown.

FAQ: PL-300 Domain 1