actualización incremental HELPPPPPPPPPPPPP

[skootz]

Hola a todos
He configurado una actualización incremental en una tabla. Tengo un problema: añade mis nuevas grabaciones a la mesa, pero no mantiene las antiguas. ejemplo: Tengo los registros de mi tabla Tab1 fechado 08/31

actualizar 09/03 : adición de 09/02 registros PERO REMOVAL de 08/31 registros ... no mantiene en stock los 10 años que he configurado.

Tab1 a 02/09
08/31 : 5000 registros ----------- 09/01 : 1000 registros

Tab1 a 03/09
09/01 ---> 1000 registros ------------09/02 : 200 registros

Gracias por tu ayuda.

[Greg_Deckler]

@skootz - ¿Pudiste resolver esto o todavía necesitas ayuda?

[skootz]

I sent an other message with explications 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 , consulte si esto puede ayudar a

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 siempre debe agregar

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