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 



Muhammad Hasnain
P BI Developer @ Algo
#LetsConnect https://www.linkedin.com/in/hasnain2587/
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
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

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 June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors