Forum Discussion

goodbyetonto's avatar
goodbyetonto
Frequent Visitor
1 year ago
Solved

Dataflow incremental refresh datetime power queries do not match gui paramaters

I am not certain yet whether this is an issue or my ignorance, however I just began to use incremental refresh on a new dataflow (SQL Server data source) and noticed the following:    The 'RangeSta...
  • lbendlin's avatar
    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.