Forum Discussion
Difference between Reference and 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.
I have the same question. I am also wondering about the DAX alternative pade gives, if this bypasses any RLS filter on the original table being used.
Good question. From the top of my head I would say that copying tables in DAX are not effected by RLS rules. Reason for this is that yu can have RLS rules operate on DAX created tables and columns. So applying the Hen and Egg rule, RLS will hit in at a later step