Duplicate and reference queries are two methods to replicate a query, but with different outcomes and use cases. This course 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.
- Learn what duplicate and reference queries are
- Learn how to implement duplicate and reference query replication
- Examine different use case scenarios
- 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
- Know how to connect to a data source with Power BI
- Be familiar with Power Query Editor
Before we get into the demonstration, let’s go over the differences between duplicate and reference queries. A duplicate query is analogous but not the same as copying a query. A duplicate query has no lasting relationship with the original query. Once a query has been duplicated, it is a new and separate query with independent copies of the data and steps that made up the original query. Deleting or changing the original query’s applied steps will have no effect on the duplicate. This is not the case for a reference query. A reference query has a relationship with the original as that of a child and parent in object-oriented programming. The reference query inherits the data and steps of the original by maintaining a reference to the original, not by making copies of them. Meaning any changes to the original or parent query will be reflected in the child reference query.
In this course, I want to look at query transformations and see how those transformations are reflected when duplicating and referencing queries.
Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.