Duplicate Queries [Video]

Difficulty: Intermediate
Duration: 4 minutes and 45 seconds
Students: 551
Rating: 4.8/5

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
Covered Topics