Duplicate VS Reference in Power Query in Power BI and Fabric Dataflows

When you work with tables and queries in Power Query and Power BI or dataflow in Microsoft Fabric, you can copy them through Duplicate or Reference actions. It has always been a question in my sessions and courses: what is the difference between these actions. The explanation is simple but very important to understand. Because when you know the difference, you will use it properly. In this video, I’ll explain what a Reference is and the difference between that and a Duplicate.
read my article about it here:

[officesuperhero]

Another great video. I learn so much from you.

[sheasafarnezhad]

Thank you so much, I have a question.
I have a huge fact table getting data from the OData feed daily snapshot.
- When I duplicate this table, does Power BI act like this is a new query and load the data twice?
Or it understand that it is the same data and shortens the refresh time?

[victorbatista]

I have a problem that I'm creating a report with RLS and I needed to use USERELATIONSHIP functions to create two different analysis from that data, but USERELATIONSHIP is not allowed with RLS.

So I'm going to create another query with the exact same data to use different relationships so I don't need to use measures with USERELATIONSHIP.

In terms of performance, which is better? Reference or Duplicate?

[kkravch]

Thank you. If it is possible, can you show how to reference a specific step in the query, not the final one. In your example if I want to reference the first query before you filtered it. I remember someone did it, but I don't remember who and how... Thanks again.