Forum Discussion
powerbiexpert22
Impactful Individual
8 hours agoIncremental Refresh - Detect Data Changes
what is the purpose of detect data changes option in incremental refresh and in which scenario it should be used or applicable?
1 Reply
- rajendraongole1
Super User
Hi powerbiexpert22 - Detect Data Changes is an optional optimization within Incremental Refresh that checks whether the maximum value of a specified Date/Time column has changed for each eligible partition. If the value remains unchanged, Power BI can skip refreshing that partition, reducing unnecessary data processing and improving refresh efficiency.
Ref: Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn
Hope this helps.