Forum Discussion
Best Approach for Incremental Refresh When Historical Records Can Be Updated
I have a Power BI report that currently imports around 7 years of historical data. During each refresh, only about 1% of the records are actually updated, so I'm exploring whether incremental refresh...
Hi Mayankb024,
Thank you MattiaFratello, fo your insights.
If you have a dependable LastModifiedDate (or another audit date/time column), you can pair Incremental Refresh with Detect data changes so that only the periods with updated data are refreshed. Once the initial refresh is complete, Power BI will refresh only the data in the configured refresh window, so this is appropriate only if your refresh period includes the timeframe in which records can be updated. Microsoft also recommends using a separate date/time column for Detect data changes instead of the same column used for RangeStart and RangeEnd.
Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn
Thank you.