incremental refresh HELPPPPPPPPPPP

[skootz]

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.

[Greg_Deckler]

@skootz - Were you able to get this resolved or do you still need assistance?

[skootz]

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 records

01/09: 1000 records

Tab1 to 03/09
09/01 ---> 1000 records

02/09 ---> 200 records

Do you have a solution for me for this?

[skootz]

No , nobody took the time to put an answer on my issue.

Thanks

[amitchandak]

@skootz , refer if this can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...

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-...
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-...