This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
 --> Transform and load the data
  --> Identify When to Use Reference or Duplicate Queries and the Resulting Impact

Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

---

When preparing data in Power BI, analysts often need to reuse an existing query to create additional tables or variations of the same dataset. Power Query provides two options for this: Reference and Duplicate queries.

For the PL-300: Microsoft Power BI Data Analyst exam, Microsoft tests whether you understand when to use each option and how they affect refresh behavior, dependency chains, and performance.

---

Reference vs Duplicate: High-Level Overview

Option	What It Does	Key Characteristic
Reference	Creates a new query that depends on the original query	Linked / dependent
Duplicate	Creates a full copy of the query and its steps	Independent

Exam insight: This is not just a UI decision — it’s a data lineage and dependency decision.

---

What Is a Referenced Query?

A referenced query points to the output of another query and builds additional transformations on top of it.

Key Characteristics

• Inherits all steps from the source query
• Updates automatically when the source query changes
• Creates a dependency chain
• Reduces duplicated transformation logic

Common Use Cases

• Creating dimension tables from a cleaned fact table
• Building multiple outputs from a single prepared dataset
• Centralizing complex cleaning logic
• Ensuring consistent transformations across tables

Exam favorite: Reference is commonly used when creating dimension tables from a base query.

---

What Is a Duplicated Query?

A duplicated query creates a complete copy of the original query, including all transformation steps.

Key Characteristics

• Independent of the original query
• Changes to one query do not affect the other
• No dependency chain
• May increase maintenance effort

Common Use Cases

• Creating a what-if version of a dataset
• Applying very different transformations
• Testing changes safely
• Preventing downstream impact

---

Impact on Refresh and Performance

Referenced Queries

• Refresh order matters
• If the source query fails, dependent queries fail
• Can improve maintainability
• May improve performance by avoiding repeated transformations

Duplicated Queries

• Each query executes its own steps
• Can increase refresh time if logic is repeated
• Easier to isolate failures
• Can lead to inconsistent transformations if not managed carefully

Exam insight: Microsoft often tests dependency awareness, not raw performance numbers.

---

Impact on Data Lineage (Often Tested)

Power BI’s View Lineage clearly shows:

• Referenced queries as downstream dependencies
• Duplicated queries as separate branches

Referenced queries create upstream/downstream relationships, which is important for:

• Debugging refresh failures
• Understanding transformation flow
• Model governance

---

Choosing the Right Option (Decision Scenarios)

Use Reference When:

• You want to reuse cleaned data
• You are creating multiple tables from a common source
• Consistency is critical
• You want changes to propagate automatically

Use Duplicate When:

• You need a fully independent version
• You want to experiment or test changes
• The transformation logic will diverge significantly
• You want to avoid breaking existing queries

PL-300 best practice: Prefer Reference for production models, Duplicate for experimentation.

---

Common Exam Scenarios

Scenario 1: Dimension Creation

You have a cleaned Sales table and need Customer and Product dimensions.

✔ Correct choice: Reference the Sales query
✖ Duplicate would repeat logic unnecessarily

---

Scenario 2: What-If Testing

You want to test a new transformation without impacting reports.

✔ Correct choice: Duplicate the query
✖ Reference could unintentionally affect dependent tables

---

Scenario 3: Centralized Data Cleaning

Multiple tables require identical preprocessing steps.

✔ Correct choice: Reference
✖ Duplicate risks inconsistency

---

Impact on the Data Model

Referenced Queries

• Cleaner model design
• Easier maintenance
• Predictable behavior
• Tighter dependency management

Duplicated Queries

• Greater flexibility
• Potential for inconsistency
• Increased refresh cost
• More manual maintenance

---

Common Mistakes (Often Tested)

❌ Duplicating When Referencing Is Needed

Leads to:

• Repeated logic
• Longer refresh times
• Inconsistent data shaping

---

❌ Referencing When Independence Is Required

Leads to:

• Unexpected changes downstream
• Hard-to-trace refresh failures

---

❌ Breaking Dependencies Unintentionally

Changing a referenced base query can affect multiple tables.

---

Best Practices for PL-300 Candidates

• Start with a base query for raw data
• Apply heavy cleaning once
• Reference for downstream tables
• Duplicate only when isolation is required
• Rename queries clearly to reflect dependencies
• Use View Lineage to validate relationships
• Know when not to reference (testing, experimentation, divergent logic)

---

How This Appears on the PL-300 Exam

Expect questions like:

• Which option ensures changes propagate automatically?
• Which choice minimizes repeated transformations?
• Why did a downstream query fail after a change?
• Which approach improves maintainability?

The correct answer almost always depends on intent and impact, not convenience.

---

Quick Decision Table

Requirement	Best Choice
Reuse cleaned data	Reference
Independent copy	Duplicate
Centralized logic	Reference
Safe experimentation	Duplicate
Dimension creation	Reference

---

Final Exam Takeaways

• Reference = dependent, reusable, consistent
• Duplicate = independent, flexible, isolated
• This topic tests data lineage awareness
• Microsoft emphasizes maintainability and correctness
• Choosing incorrectly can break refresh or logic

---

Practice Questions

Go to the Practice Exam Questions for this topic.