Forum Discussion
Incremental Refresh: Process data out with Incremental Refresh period
- 2 years ago
You can either force a full refresh, or you can refresh individual partitions via XMLA calls.
Keep in mind that Incremental Refresh expects immutable data. It is not designed for your scenario (which would require differential refresh)
By changing the report meta data and re-publishing the report to the workspace. That triggers a series of events, namely that incremental refresh partitions are deleted and a single partition is created. After that is complete the next refresh request will recreate the incremental refresh partitions.
Of course this is something you should avoid doing at all cost. Instead, use the XMLA command for a full refresh of the entire table (see the article I linked to), which will initiate the full refresh of all the table partitions AND of the linked tables/partitions if applicable. For example if you have auto date/time enabled, this will also refresh all these localcalendar tables.