Forum Discussion

BobbyEire's avatar
BobbyEire
Regular Visitor
6 years ago

Error using Detect Data Changes Re: Incremental Refresh

Hey all,   I've configured Incremental Refresh to work on my table using the settings below.     However when i attempt to enable "Detect Data Changes" on the same table using the settings...
General Comment
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi BobbyEire ,

 

If you select the Detect data changes checkbox, you can select a date/time column used to identify and refresh only the days where the data has changed. This assumes such a column exists in the source system, which is typically for auditing purposes. This should not be the same column used to partition the data with the RangeStart/RangeEnd parameters. 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. 

 

For reference:

Incremental refresh in Power BI

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

  • BobbyEire's avatar
    BobbyEire
    Regular Visitor
    6 years ago

    Hey Amy, 

     

    I'm using 2 separate columns:

     

    [Sync Created Date Time] for the incremenatl refresh

    [Sync Date Time] for Detecting Data changes.