Create a duplicate from a main table but will also update when the main table changes.

Question

Hello everyone,&nbsp;I have a main source of data into a table which updates automatically every week due to Power Automate. I want to ask since I'm making multiple tables due to different roles to be placed in RLS. I am currently a beginner and would like to ask what type of logic is applicable to these?My idea is&nbsp;Main source -&gt; creates multiple duplicates(manual) -&gt; cleans data through power query only getting the important data from different roles -&gt; data will also change depending on the main source if there are new or deleted data inside.&nbsp;&nbsp;my main point here is that the duplicate tables will also change if the main table has updated data inside.&nbsp;If there is another way on how I could do this, please help me.

andredelange · Accepted Answer

What about using Reference instead of Duplicate? The Reference query is then just equal to the last step in your main query. That way if the main table changes, the Referenced table will automatically change as well when you refresh.

Forum Discussion

Create a duplicate from a main table but will also update when the main table changes.

2 Replies

Related content

Working with copy job and creating duplicates

Duplicate ranking

Create table to remove duplicates

Creating Relationships with duplicative values

Table Merge creates duplicate records