Forum Discussion
Incremental refresh - Alternate RangeStart and RangeEnd
Hello Lionel,
Thank you for your answer. Actually, whilst it is indeed impossible to set alternate RangeStart nor RangeEnd, it is possible at a later stage to change different archive and refresh periods by table.
I will confirm when fully implemented
Marc-Alexis , Can you explain with an example.
I think every table can have its won date if needed
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
For instance, 3 tables are relying on a RangeStart=01/01/2017 and RangeEnd=01/01/2050 with the rows in the past 3 years stored and a resfresh for the rows in the last 60 days.
The other table of the same PBI would require an incremental refresh with the following attributes:
RangeStart=01/01/2000 and RangeEnd=01/01/2050 with also the rows in the past 3 years stored and a resfresh for the rows in the last 60 days.