Forum Discussion
Incremental refresh
Hi all,
1 - Is it possible to set an incremental refresh running on monday to saturday, and a full refresh on Sunday for a same table ?
2 - If I use an incremental refresh for a table, using a technical date field. For example, every day, I refresh the last 7 days and my archive keeps 5 years of data. We are the 11/30/23, if I modify a line in my database (inserted in september, and modified today), the new technical date for this line is today. Will I have this line twice in my dataset tomorrow morning or not? If not, how does it works? If yes, how do I avoid this scenario ?
Thx by advance
2 Replies
Hi. I'm not strongly familiarized with all the incremental refresh settings, but I think this can help.
Regarding refresh, the only way to make that kind of deep settings would be building the refresh setting with the Enhanced Refresh Power Bi Rest API Request. This will only be supported with premium environments (check requirements): https://learn.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh
That's the only way to run a refresh with settings for partitions. Otherwise the configured refresh of the UI will always be the same.
For number two it's kind of tricky. The incremental refresh policy have settings to specify how you want to control data changes, you can read about that in here: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#define-policy
I hope that helps,
