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

[Lestify]

Hello everyone,

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 
Main source -> creates multiple duplicates(manual) -> cleans data through power query only getting the important data from different roles -> data will also change depending on the main source if there are new or deleted data inside. 

my main point here is that the duplicate tables will also change if the main table has updated data inside.

If there is another way on how I could do this, please help me.

[AndreDeLange · Accepted solution]

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.

[Lestify]

Thank you so much, this would work out just fine!