Performance Difference

[mh2587]

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 

[v-xiaoyan-msft · Accepted 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.

[manikumar34]

@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