Forum Discussion
Difference between Reference and Duplicate
Hi All,
I am a newbie in Power Bi. Can anyone explaine me
what is the actual Difference between Reference and Duplicate of a table.
Please see the below image.
Thanks in Advance,
Maadi.
Reference & Duplicate
In simple terms, Duplicate will duplicate the code of the query while Query Reference will only refer the result of the query.
Duplicate is generally used when you would like to create a similar query and you do not want to type the same code. You can make changes to this query.
Reference in Query means you would like to use that Query results in some other queries where your original query remains as a base Query and it can be used in other queries for the further processing.
10 Replies
In simple terms, Duplicate will duplicate the code of the query while Query Reference will only refer the result of the query.
Duplicate is generally used when you would like to create a similar query and you do not want to type the same code. You can make changes to this query.
Reference in Query means you would like to use that Query results in some other queries where your original query remains as a base Query and it can be used in other queries for the further processing.- Thank you Bhavesh.
Hi,
What about performane differnces between the 2 methods?
Thanks
Well i believe the Duplication does impact as creating another OBJECT in the memory, where as referencing does not.
2016....... but for me the right and simple answer. Thanks
For an example if you need to filter same data set to create seperate tiles, like if you want to pick only today date figures or any date sequence. you can use the same query as a base and refrenec it rather than duplicating the query.
Although both can be used for the same purpose, but REFRENCING the same dataset is an eligent approach...
