Forum Discussion
Incremental Refresh & Appending Current Data to Large Static Data Set
Since you are already doing incremental refresh there is no real need for a Historical and Current table - this can be a single table with appropriately sized partitions. Manage your partitions as you see fit, either via the Power BI Service or via XMLA.
I'm not sure you understood my post.
The whole point of my post is creating the single table from two pre-existing tables and avoiding a full refresh on all 3 tables. There's no reason to reload all the data each time.
That's the idea of incremental refresh. Your single table has multiple partitions, but only very few of them (ideally just the newest) will be reloaded when you issue a refresh request. The other partitions of that table are left alone (except for the consolidations at the end of periods, if you choose to do so).
Yes I know about inrcemental refresh and am using it per my original post