Forum Discussion

aume1's avatar
aume1
Helper I
4 years ago

Incremental Refresh is not working when parameters are set

Hi,    I have a report that has Incremental Refresh (henceforth IR) applied to it. The purpose of it is to let the report store the past 10 months of date + current month while only updating the la...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Two comments:

 

- The values of RangeStart and RangeEnd that you specify in Power Query have nothing to do with the actual workings of the Incremental refresh.  They are placeholders that you can use to limit the amout of data to use for development (if you so wish)

- You have "Detect data changes" enabled but the field is blacked out. This field must be different from the field you use with the RangeStart/RangeEnd filters.  It also has a massive impact on the way Incremental Refresh works.

aume1's avatar
aume1
Helper I
4 years ago

Thanks for the reply. 

 

Detect data changes is enabled with a column in the table which is updated daily to record when the new rows were inserted to the table, which I assume would be picked up by PBI service to only refresh the newly updated rows in the table within the defined refresh period of 10 days. Is this a correct assumption on this feature?

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Yes, that is correct for scenarios where rows get added. It will not help like this for rows that are changed or deleted.  It will also massively increase the required space as it creates a second copy of your partitions ("canary") to do its thing.