Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
@skootz - Were you able to get this resolved or do you still need assistance?
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
@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-...
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-...
User | Count |
---|---|
119 | |
78 | |
59 | |
52 | |
48 |
User | Count |
---|---|
171 | |
118 | |
60 | |
59 | |
54 |