cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mh2587
Post Patron
Post Patron

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 

1 ACCEPTED SOLUTION
v-caitlyn-mstf
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-caitlyn-mstf
Community Support
Community Support

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.

View solution in original post

manikumar34
Solution Sage
Solution Sage

@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





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors