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