Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
skootz
Frequent Visitor

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 4
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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?

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

Thanks

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.