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
Also, does the order of applied steps matter in terms of rolling the native queries into one?
Say if we had the first 5 steps as native queries that are folded
the next 3 are not supported as native query
then we have another 2 queries that are native.
Will PBI send back the 7 native queries rolled into one? Or will it be seperated out as the 5 rolled into one query and sent then the other 2 queries rolled into one and sent back?
It wouldn't fold anything after an action that "breaks" it. Because at that point it needs to be processed in Power Query before it goes to the next step.
I think you've got it!
Hi Syk ,
So essentially, as soon as you hit an applied step that is not supported as Native Query, nothing after that will be identified as a native wuery - even if the step is supported by it such as removing a column?Do you know if the Native queries that are sent back to the source, utilise the DB's index functioning if it has indexing?
I understand, but just it utilise the databases indexing to retrieve the data quicker is my point?