Forum Discussion
Incremental Refresh & Appending Current Data to Large Static Data Set
Hello 😊 I am designing a report that has two tables (Historical & Current) loaded from a Power BI Dataflow into a single Power BI dataset, which are too large to publish if I load the data before h...
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