Incremental Refresh data store

[awhiteway]

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!

[v-jayw-msft · Accepted solution]

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.

[awhiteway]

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

[GilbertQ]

That would make perfect sense as to why you are still seeing data for Mar 2020

[awhiteway]

Hi there - not sure how that makes sense. If my dates are under 5/1 and it's set to store 5/5 or later, why would it still be showing? Apologies in advance if I'm being super dense here.

[GilbertQ]

Hi there

That could be because you have got them both configured to be the same?

[awhiteway]

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

[GilbertQ]

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

[awhiteway]

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?

[GilbertQ]

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.