Forum Discussion
Incremental updates
Hello. I have a few questions about incremental updates, I am sure that here I will find the best answer. In my company we use to have a table schema wich constist in a table with the informa...
I assume you mean the Incremental Refresh feature.
You can certainly create an incremental Refresh setup for a static table in order to store it into different partitions in the Power BI Semantic Model's table. However there is not much of an advantage to it if the original data source is small and fast. Incremental Refresh is more suited for data sources that are large and slow (and ideally immutable).
Note there is a variation on the Incremental Refresh setup that allows you to connect to the "Today" partition in Direct Query mode and to all other partitions via the Semantic Model. That might be a fit for your scenario.