Forum Discussion
Incremental refresh - power bi refresh automatically
Thanks for your response :
I have already configured the incremental refresh without these 3 tables, only, I have encountered a problem :
I set up an incremental refresh on a table. I have a problem: it adds my new recordings to the table, but it does not keep the old ones. example: I have the records of my table Tab1 dated 08/31
refresh 09/03 : addition of 09/02 records BUT REMOVAL of 08/31 records ... it does not keep in stock the 10 years that I have configured.
Tab1 to 02/09
08/31 : 5000 records
09/01 : 1000 records
Tab1 to 03/09
09/01 ---> 1000 records
09/02 ---> 200 records
Do you have a solution for me for this ?
Incremental refresh stores daily (if set like that) new records based on a RangeStart and RangeEnd (date / time) filter ? I ask it to update every day and store me on 5 years but it does not store anything it updates the table for me and deletes the records from 08/31 when it should keep them.
Thanks,
Hi skootz ,
The filter on the date column is used to dynamically partition the data into ranges in the Power BI service. Incremental refresh isn't designed to support cases where the filtered date column is updated in the source system. An update is interpreted as an insertion and a deletion, not an actual update. If the deletion occurs in the historical range and not the incremental range, it won't get picked up. This can cause data refresh failures due to partition-key conflicts.
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.
