power bi difference between duplicate and reference | power bi tutorial for beginners

Опубликовано: 07 Март 2025
на канале: PowerBI Zone
4,252
79

#powerbi #powerbitutorials #duplicate #Reference #powerbizone
In this Power BI tutorial I have tried to explain the difference between duplicate and reference query in Power BI.
What is the difference between duplicate and reference queries?
Duplicate Query: Duplicate will copy an entire table with all the applied steps.
The duplicated table ,lets call it “Dup” will be independent of the Original table.
Which means any changes you do to the Original table will not be reflected in “Dup”

Reference Query:
It will also copy the original Query but the Reference Query (lets call it “Ref”) will have only one step (which will source from its Original )
It will not have the applied steps of Original Query.
Any changes you do to the Original table will be reflected in “Ref”

If you try to delete the main Query ,you cannot ,since it is dependent on the reference query.
For more details check out my blog:
https://powerbizone.com/power-bi-what...

You Can download the pbix file from below link.Dont forget to open it via Power BI desktop
https://drive.google.com/file/d/1kAal...