Forum Discussion
What is the function of Detect Data Changes in Refresh?
Hi, Anonymous
Please refer to Incremental refresh and real-time data for datasets .
The Detect data changes setting enables even more selective refresh. You can select a date/time column used to identify and refresh only those days where the data has changed. This assumes such a column exists in the data source, which is typically for auditing purposes. This should not be the same column used to partition the data with the RangeStart and RangeEnd parameters. The maximum value of this column is evaluated for each of the periods in the incremental range. If it hasn't changed since the last refresh, there's no need to refresh the period. In this example, this could potentially further reduce the days incrementally refreshed from 3 to 1.
Related tutorial:
Power BI Incremental Refresh - Understanding Detect Data Changes
Best Regards,
Community Support Team _ Eason
Advocate IIn your example (case 1) both rows got refreshed because the MAX(last-change-date) changed for the partition 2022-02, and so it happens that both rows belong in this partition. Partitions are defined by the column where you put rangeStart/End parameters (creation-date in your case).
Case 2: exactly, archived periods are not refreshed at all, only the initial load. That is why we only use this when we know that hitorical records cannot change.