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
When you create something like a data flow in the Power BI Service, it will allow you to transform the data just like in Power BI Desktop. It's using Power Query Online in that case. Essentially the exact same thing, just online. 🙂
Thank you for this! 🙂 One more thing you may know thr answer to, how can Query Folding occur when the storage mode of data is import?
If the data is being imported thus being locally stored for use, how can query folding be beneficial in terms of perfomance because it isnt relaying back direvtly to the DB?
Thanks! 🙂