Forum Discussion
Dataflow incremental refresh datetime power queries do not match gui paramaters
- 1 year ago
The parameter values for RangeStart and RangeEnd in Power Query are not relevant for the actual partitions. They only help you the developer to limit the development data.
In fact, with a dataflow you have no control over these parameters or where they are placed in the Power Query (for some unexplicable reason they are always placed at the end which makes no sense whatsoever - the filter should apply as soon as possible).
Ignore them and check the refresh details of the dataflow to make sure you see the generated partitions.
Ideally you would do an incremental refresh on a semantic model, not a dataflow.
The parameter values for RangeStart and RangeEnd in Power Query are not relevant for the actual partitions. They only help you the developer to limit the development data.
In fact, with a dataflow you have no control over these parameters or where they are placed in the Power Query (for some unexplicable reason they are always placed at the end which makes no sense whatsoever - the filter should apply as soon as possible).
Ignore them and check the refresh details of the dataflow to make sure you see the generated partitions.
Ideally you would do an incremental refresh on a semantic model, not a dataflow.