cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mh2587
Impactful Individual
Impactful Individual

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.

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 Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!