Forum Discussion
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 store and refresh (w/ detect data changes) 2 months of data. The column being filtered is a "MonthID" column using the month start datetime (4/1/2020, 5/1/2020). The problem is that March is still being stored. Why would I still be seeing March data at this point? The dataset is hefty so I am trying to only ever have current and previous month. After looking at SQL server, I can confirm that March is no longer being refreshed, but I have the same number of months under the "store rows" part and it seems to not be aligning.
Thank you!
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.
9 Replies
- Hi there
That could be because you have got them both configured to be the same?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
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! The column that is being filtered by the parameters is a Month Start Date column (so would display 3/1/2020 for the March dates) which is why I'm confused why it's still being stored
- That would make perfect sense as to why you are still seeing data for Mar 2020
