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
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! 🙂
it is relaying back to the db, because when you refresh the power bi report, power bi grab all the data again and go all the applied steps ib power query.
Thats what i couldnt understand, it refreshes to the db first and then goes through the applied steps right?
So essentially it enables it to just go through the applied steps quicker as some may be native query?jakaihammuda , true, when there's query folding what it does is that it pushes the transformations from the steps into the db, resulting less load on power query.