Forum Discussion
Merging tables with static data and to update data
Anonymous , Merge in Power Query and Union in DAX should work with new data as long as that is coming in both these tables
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Union(TableA, TableB)
Or use selectcolumns to get the right columns
Also refer: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Thanks for this.
I had a similar problem, but my old data was static and needed to update current data on a regular basis but did not need to update prior data unless the user access rights to prior data changed. But the old data was causing long delays in refresh.
Following this guidance, I used Power Query to create two identical tables; a current and prior. Both were set to Enable Load, but only the Current table was set to include in report refresh.
When the dasboard was delivered as a template, the prior data was pulled in intially. But subsequently only the current data was retrieved.