Forum Discussion
Adding a step in Power Query (desktop) breaks query folding when source is a dataflow
I am attempting to pull a number of dataflows into my dataset via Power Query desktop. Since I'm using premium and have enabled the enhanced compute engine, I should be able to fold the queries. And ...
Hi v-yalanwu-msft,
I found that if I instead use the PowerPlatform.Dataflows connector, then I can add steps (or at least basic steps), without breaking the query folding. But unfortunately when I try to use the PowerPlatform.Dataflows connector, I can't seem to get it to work with my parameter that points to the desired workspace.
Take a look at the Advanced Editor to see the different navigation steps. You can insert one or more text parameters in place of the hard-coded workspaceID, dataflowId, and/or entity.
Pat