The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
78 | |
66 | |
52 | |
50 |
User | Count |
---|---|
121 | |
120 | |
78 | |
63 | |
62 |