Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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
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.
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |