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
What is Power Query Online?
I dont fully understand what that is or how to even find it at all?
Thanks! 🙂
Are you familiar with the Power BI Service and publishing reports?
Yes
Hello jakaihammuda ,
it's called Data flows.
check it out here https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create
Thank you for this! 🙂 One more thing you may know the 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 directly to the DB?
Thanks! 🙂
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! 🙂