Forum Discussion
Query Folding Icons in Power Query
Unfortuntely, the indicators are only for Power Query Online meaning you won't see it in Power BI Desktop's Power Query Editor.
Hello jakaihammuda ,
it's called Data flows.
check it out here https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create
all transformations are done when the data is refreshed, the query folding transformations are pushed to the data source while the non query folding steps are done in power query.
To piggyback on this... Every applied step that does not break the query folded is rolled up into a single query to the database (hence 'query folding' it's just folding those steps into the query!)
However, query folding does not happen if you explicitly state a query in the connection. There are also steps that will break the query fold and you may notice longer processing times.
There's not a great way to see if query folding is occuring in Power Query (desktop) but you can right click an applied step and if you can click 'View Native Query', query folding is working at least until that step!