Forum Discussion
Performance Difference
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
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 _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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
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 _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
