Forum Discussion
incremental refresh HELPPPPPPPPPPP
Hello everybody,
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
Thanks for your help.
4 Replies
- amitchandak
Super User
skootz , refer if this can help
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Incremental should always add
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-or-date-instead-of-the-default-datetime/ - Greg_Deckler
Community Champion
skootz - Were you able to get this resolved or do you still need assistance?
No , nobody took the time to put an answer on my issue.
Thanks
I feel another message with explanations on my issue.
I have already configured incremental update without these 3 tables, only, I have encountered a problem:
I have set up an incremental update on a table. I have a problem: it adds my new recordings to the table, but it doesn't keep the old ones. example: I have the records in my table Tab1 dated 08/31
update 03/09: addition of 02/09 records BUT REMOVAL of 08/31 records ... does not keep in stock the 10 years that I have configured.
Tab1 to 09/02
08/31: 5000 records01/09: 1000 records
Tab1 to 03/09
09/01 ---> 1000 records02/09 ---> 200 records
Do you have a solution for me for this?
