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.
Thank you for the reply! I'm not sure why it being the same would cause this issue? Since it's the same I'd expect the refresh months to be the same as the months being stored
Hi there
I think I figure it out.
The reason is that it goes back 2 months from the current date.
Because todays date is 05 May 2020 (Here in Australia) it will then go back to 05 Apr 2020
I think I figure it out.
The reason is that it goes back 2 months from the current date.
Because todays date is 05 May 2020 (Here in Australia) it will then go back to 05 Apr 2020
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.