Forum Discussion
Solved
Query Folding Icons in Power Query
Hello, Im trying to understand more about Query Folding, Im aware of when it can be used in terms of storage modes etc and how some steps allow for query folding and some dont. However, when re...
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
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.