Forum Discussion
Incremental Refresh: Dates Earlier than 'RangeStart' once Published
You are doing too many things at the same time.
First of all - the values of RangeStart and RangeEnd in the desktop have absolutely no impact on incremental refresh. They are only placeholders that help you - the developer - to limit the data you develop with.
Second - in your Power Query make sure that both parameters are included in your query filter but only one of them can be inclusive, the other one must be exclusive
Third - remove all the extra options and only focus on getting incremental refresh to work
Fourth - Every time you make structural changes to your report and publish it to the workspace your incremental refresh will have to restart. The partitions are only recreated during the next refresh.
Fifth - the only sure way to know that your incremental refresh is working correctly is to observe the refresh timestamps of the partitions. If you only see one partition then incremental refresh is not working.
You are doing too many things at the same time.
First of all - the values of RangeStart and RangeEnd in the desktop have absolutely no impact on incremental refresh. They are only placeholders that help you - the developer - to limit the data you develop with.
Second - in your Power Query make sure that both parameters are included in your query filter but only one of them can be inclusive, the other one must be exclusive
Third - remove all the extra options and only focus on getting incremental refresh to work
Fourth - Every time you make structural changes to your report and publish it to the workspace your incremental refresh will have to restart. The partitions are only recreated during the next refresh.
Fifth - the only sure way to know that your incremental refresh is working correctly is to observe the refresh timestamps of the partitions. If you only see one partition then incremental refresh is not working.
When I publish the report on service, and refresh the model, only data within the interval between RangeStart and RangeEnd continues to come.
Results on desktop:
Results on service after a five minutes refresh:
It's a ODBC query. I followed this video's instructions https://www.youtube.com/watch?v=x7q1DHf8wE4 and injected the date directly on query.
I carried out the same procedure in another report, with the difference that there the RangeStart was a much earlier date (01/01/2023). It brought the "historical data", due to this RangeStart, and then the incremental updates are working, as the time taken is very low.
Considering the settings below, in the first refresh to the Service, shouldn't the data already appear between 01/01/2019 and 05/30/2024?