Forum Discussion
incremental refresh stop
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 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.
Regards
Hi 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
Don't know what is meant by "overidden"...with what?
That makes less sense, since your incremental refresh was working fine for a while.
In case of override you wouldn't have a working incr. refresh at all.
I would try with a RangeEnd in a distant future.
You have nothing to loose here.
Regards