Incremental Refresh in Power BI: Handling Historical Data Updates Beyond the 2-Day Delta

[Anonymous]

Hello, we plan to set up an incremental refresh. The history is over two years and the desired delta to refresh the data is 2 days. However, historical data can sometimes be updated and modified. What happens if my delta is two days and tomorrow data from a year ago is updated?
Thx !!!!

[Idrissshatila]

Hello @Anonymous ,

if you performed an incremental refresh for the last two days and your historical data gets updated, then the update won't be reflected in your power bi.

Learn all aboubt incremental refresh from this video https://youtu.be/Kui_1G6kQIQ?si=Q0ojv0cMgn_ouCTs

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Anonymous]

If I use the "Detect data changes" option, can I set this option for the last two years? Will this meet my needs?