Duplicate and Reference Query Transformations in Power BI

Duplicate and reference queries are two methods to replicate a query, but with different outcomes and use cases. This lesson does a side-by-side comparison of duplicate and reference queries. We see how to replicate a query with each method, what are the pros and cons of each method, and possible side-effects you may encounter with each of them.

Learning Objectives

• Learn what duplicate and reference queries are
• Learn how to implement duplicate and reference query replication
• Examine different use case scenarios

Intended Audience

• Students who want to learn about the differences between duplicate and reference Power BI queries
• Students preparing for the PL-300: Microsoft Power BI Data Analyst exam 

Prerequisites 

• Know how to connect to a data source with Power BI
• Be familiar with Power Query Editor