Forum Discussion
Reference vs Duplicate tables in Power Query, Power BI
Jocie , If you want to create a reference, do not do a change in the original script.
It should be like
Base Table
Created D1,D2, D3
Created a Fact Using Base Table, D1, D2, D3 using merge as new.
If you want to change something to base, then before any change duplicate else you will have all the steps, when you copy.
I would prefer the first approach. not to disturb the base table
Jocie , If you want to create a reference, do not do a change in the original script.
It should be like
Base Table
Created D1,D2, D3
Created a Fact Using Base Table, D1, D2, D3 using merge as new.
If you want to change something to base, then before any change duplicate else you will have all the steps, when you copy.
I would prefer the first approach. not to disturb the base table