Forum Discussion

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
5 years ago
Solved

Working of Incremental Refresh when detect data changes is enabled

Hello,   Can anyone guide me as to what is the backend process when Incremental Refresh is configured along with 'Detect data changes'. Would it refresh all the data and see if there is any change...
General Comment
Interesting Links
  • rajulshah's avatar
    rajulshah
    5 years ago

    Hello everyone, 

     

    The detailed documentation of the working of Incremental Refresh can be referred to here. Understanding this topic will help you understand better about the working of Incremental Refresh when 'Detect data changes' is enabled.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hi rajulshah,

this is a difficult topic, where I have not seen many examples yet.

The documentation says the following:

The maximum value of this column is evaluated for each of the periods in the incremental range. If it has not changed since the last refresh, there is no need to refresh the period.

 

So it it would just look into the field which is configured in 'Detect data changes'.

 

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#detect-data-changes