cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mh2587
Super User
Super User

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

#LetsConnect https://www.linkedin.com/in/hasnain2587/
1 ACCEPTED SOLUTION
v-xiaoyan-msft
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-xiaoyan-msft
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors