Forum Discussion
Query Folding in PowerBI Dataflows with PowerBI Embedded Capacity?
My organization utilizes dataflows extensively and is in the process of working to make our flows more efficient. I've been operating under the assumption that linking to a table from an already extracted flow would allow for query folding. Lots of Microsoft documentation indicates that this is true. However, I do not see the same query folding indicators in my query step view that I see in documentation and tutorials. Microsoft indicates that this feature is available for premium, and I'm wondering if it's potentially not available for embedded?
One additional quirk. When I look at a flow's refresh history and download one example it does say cached+folded for queries in the flow.
Can anyone confirm if query folding really does work in dataflows on an embedded capacity?
It depends. If it is dataflow to dataflow, it does. If it is dataflow to dataset, maybe. If the Enhanced Compute Engine is on for the flow, and the dataset uses the PowerPlatform.Dataflow connector and not the PowerBI.Dataflow connector, then it will fold.
2 Replies
It depends. If it is dataflow to dataflow, it does. If it is dataflow to dataset, maybe. If the Enhanced Compute Engine is on for the flow, and the dataset uses the PowerPlatform.Dataflow connector and not the PowerBI.Dataflow connector, then it will fold.
One caveat - it will only fold for statements that fold. Filtering, group by's, etc, but most changing data types, etc. won't fold obviously. Dataflows fold the same functions that Power Query in the desktop does. It is as much art as science.