Forum Discussion
incremental refresh stop
i defined 12 months period to retain historical data and 1 month period for refreshing incremental data while setting up the refresh policy
i gave the range start and range end parameters values from 01-Oct-2025 until 30-Sep 2025 , the incremental refresh was working fine until 30th Sep 2025 and stopped from October month onwards , what could be the issue?
Hi powerbiexpert22,
I am sure whatever the dates you provided in the PBI desktop application that doesn't effect on incremental refresh. Those dates are just development purpose.
I would suggest you that please check once in the SSMS how the partions are working and latest date&time stamp, in this way you will came to know whether the incremental refresh is updating data or not.
I hope you can able to see 12 partitions for 12 months archived data(from 1/11/2024 to 31/10/2025) and 1 month(1/11/2025 to 30/11/2025) for data refresh.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
13 Replies
Hey powerbiexpert22 ,
what do you mean?
I'd say works as designed...at least it looks a bit weird.Having this on your data column applied you won't get new data after September 2024.
BestHi sergej_og ,
I have corrected the post, it was typo
Hey powerbiexpert22 ,
I thought so.
I think you still have a typo there...."values from 01-Oct-2025 until 30-Sep 2025", makes less sense. Oct 2025 is bigger that Sept 2025.
But I think the issue is the same. You want to have the refresh until 30-Sep-2025. Ok, but we are now in Nov-2025.
Your data is not going to be refreshed because Sep-2025 is past.
What do you think?
Maybe I don't get your point completely.
Can you paste your incr. refresh setup for the tabel pls.
Regards
Hi sergej_og ,
sorry, it was my bad..values set were below
Range Start: 01-Sep-2024
Range End: 30-Sep-2025
Yeah, I was sure you this range.
To achieve your goal (refresh 1 month) you need to set the Range End paramenter to something like 01.01.2040 - meaning in the distant future.
My setup is looking like this (in PQ):On the table:
Hope this helps you.
RegardsHi sergej_og , i read in microsoft documentation that power bi service overrides range start and range end parameters, in this case, does it still matter which value i specify in range start and range end parameters in power bi dekstop?, please see below documentation and post
Solved: Incremental Refresh | RangeStart vs RangeEnd Param... - Microsoft Fabric Community
Hi powerbiexpert22,
I am sure whatever the dates you provided in the PBI desktop application that doesn't effect on incremental refresh. Those dates are just development purpose.
I would suggest you that please check once in the SSMS how the partions are working and latest date&time stamp, in this way you will came to know whether the incremental refresh is updating data or not.
I hope you can able to see 12 partitions for 12 months archived data(from 1/11/2024 to 31/10/2025) and 1 month(1/11/2025 to 30/11/2025) for data refresh.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.Hi ajaybabuinturi ,
if the range start and range end does not matter then what could be the reason of stopping incremental refresh
Hi powerbiexpert22,
Did you verify the SSMS ??
Hi powerbiexpert22,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to ajaybabuinturi & sergej_og for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
