Forum Discussion
Resolver IIIncremental Refresh - Keep yesterday's data and refresh today's.
Data in the table changes every dayThat means your data is unsuitable for incremental refresh. Incremental refresh expects immutable data that can be added on to, but never needs to be updated.
You are looking for differential refresh. That is not something Power BI can do.
Your best bet is to extend the refresh window to refresh not the last day but the last 14 days (for example) to catch most changes, and to run occasional full refreshes to cover cases when older data has changed.
Note that you can also manually or programmatically refresh individual partitions.
Note that you have selected "Only refresh complete days" which is most likely not what you want.
Super UserData in the table changes every day
That means your data is unsuitable for incremental refresh. Incremental refresh expects immutable data that can be added on to, but never needs to be updated.
You are looking for differential refresh. That is not something Power BI can do.
Your best bet is to extend the refresh window to refresh not the last day but the last 14 days (for example) to catch most changes, and to run occasional full refreshes to cover cases when older data has changed.
Note that you can also manually or programmatically refresh individual partitions.
Note that you have selected "Only refresh complete days" which is most likely not what you want.
Late reply but for those that come here after a search:
I believe it needs an immutable datetime column, not necessarily that the whole row needs to be immutable. If you have an immutable column like a creationdate log column you can use that together with detect data changes on a modifieddate log column. If you set your partitions at the month level for example it will scan each month for a change in last modifieddate and then refresh the entire partition.