Forum Discussion
Incremental Refresh Last Step, can be moved?
GuilleATT Your post is inconsistent. You talk about datasets but then show details for a dataflow.
The filter step can be applied earlier in a Power Query script on Power BI Desktop (ie for a dataset)
You can move the step forward in the dataflow Power Query editor on the service but the moment you save the dataflow it will rearrange the steps again and put the filter step back at the end. That is really, really annoying and one of the reasons I don't use incremental refresh for dataflows.
I really hope they remove that silly limitation at some point (together with the silly extra error check step that they insist on adding)
Super UserGuilleATT Your post is inconsistent. You talk about datasets but then show details for a dataflow.
The filter step can be applied earlier in a Power Query script on Power BI Desktop (ie for a dataset)
You can move the step forward in the dataflow Power Query editor on the service but the moment you save the dataflow it will rearrange the steps again and put the filter step back at the end. That is really, really annoying and one of the reasons I don't use incremental refresh for dataflows.
I really hope they remove that silly limitation at some point (together with the silly extra error check step that they insist on adding)