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.
Community SupportHi pmaviles ,
1. When initially configuring incremental refresh in Power BI Desktop, the parameters (RangeStart and RangeEnd) are used to filter only a small period of data to be loaded into the model. When published to the Service, with the first refresh operation, the Service creates incremental refresh and historical partitions and optionally a real-time DirectQuery partition based on incremental refresh policy settings, and then overrides the parameter values to filter and query data for each partition based on date/time values for each row. That is, the date range displayed after refreshing on Service is independent of the parameter value.
2. Partitions are created for and named by period granularity: Years, quarters, months, and days. Historical partitions contain rows by complete period up to the refresh period. That is, if you select the history period as "12 Months", then the minimum granularity of the history partition is "month". So the earliest date is "2021-2-1".
Table partitions can be seen using Tabular Editor.
For more information, please refer to: https://docs.microsoft.com/power-bi/connect-data/incremental-refresh-xmla#partitions
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.