Forum Discussion
Solved
Incremental Refresh data store
Hi all! Hoping someone else may have encountered this. As my month rolled over into May, I'm seeing incremental refresh keep more data than I'm telling it to. I currently have it set up to both s...
Hi awhiteway ,
In Power BI last 2 months means March to May, you need to modify 2 to 1.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The refresh is only refreshing April (which follows) but March is still stored in the dataset, I'd have expected March to be deleted since I specified store 2 months - do I understand the incremental refresh settings wrong?
Todays date is 05 May 2020
If I go back 2 months from todays date (05 May 2020) (which you specified in your incremental refresh configuration) from today it would be 05 March 2020.
If I go back 2 months from todays date (05 May 2020) (which you specified in your incremental refresh configuration) from today it would be 05 March 2020.