Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a question popping in my mind from yesterday which will be better in performance between Refrence Query and Duplicate Query Anyone will clear this confusion
Thank you
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Solved! Go to Solution.
Hi @mh2587 ,
Duplicate and Reference are two different actions, and they are also different from Copy and Paste of a query. Duplicate will give you an exact copy of the query with all steps, Reference will create a reference to the original query instead as a new query. Duplicate is a good option to choose when you want the two copies to be isolated from each other, Reference is a good option when you create different branches from one original query.
Here's a similar thread and a blog that will hopefully help you answer this question better:
Reference vs Duplicate in Power BI (Also mentioned above.)
Difference between Reference and Duplicate
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mh2587 ,
Duplicate and Reference are two different actions, and they are also different from Copy and Paste of a query. Duplicate will give you an exact copy of the query with all steps, Reference will create a reference to the original query instead as a new query. Duplicate is a good option to choose when you want the two copies to be isolated from each other, Reference is a good option when you create different branches from one original query.
Here's a similar thread and a blog that will hopefully help you answer this question better:
Reference vs Duplicate in Power BI (Also mentioned above.)
Difference between Reference and Duplicate
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@mh2587 ,
For this you will also need to understand the concept of query dependancy.
Use the below link to understand Deuplicate vs Reference with query dependancy.
https://radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |