Forum Discussion
Solved
Incremental Refresh, Detect changes not working
Hi I can't seem to figure this out. I'm testing Incremental Refresh and can only get it to "half work". I have a test dataset, going back 6 months (April 15th, 2024), with columns: ID, CallDate...
That is by design. "warm" partitions are not part of the change tracking.
Extend your "hot" window. For example 60 days instead of 14.
Have you given the Power BI Service a chance to actually set up the partitions and fill them? Every time you make structural changes to your report and/or semantic model the incremental partitions will be reset.
I believe so. I even rebuilt the dataflow from the ground up with the final settings for Incremental Refresh.
I have gotten one step further though - if I update values where CallDate is within the 14 days, these updates get picked up in the refresh. But I still can't get updated values for records where CallDate is before 14 days and AdjustedDate is within 14 days.