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 in the data? Or it would just look into the field which is configured in 'Detect data changes'?

Please mention any links where it has been explained that how Incremental Refresh works.

Thanks in advance.
Can you guys please help? Greg_Deckler parry2k mwegener v-lionel-msft 

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.

3 Replies

  • 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

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi rajulshah ,

     

     

    Take the configuration in the document as an example.
    If the "Detect data changes" option is not turned on, the data of the last 10 days will be refreshed each time the refresh schedule is executed.
    If the "Detect data changes" option is enabled, the refresh range will be further reduced (only rows updated in 10 days.).

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    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.