Forum Discussion
Query Folding Icons in Power Query
- 2 years ago
Unfortuntely, the indicators are only for Power Query Online meaning you won't see it in Power BI Desktop's Power Query Editor.
- 2 years ago
Hello jakaihammuda ,
it's called Data flows.
check it out here https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create
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.
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?
- Syk2 years agoResident Rockstar
I think you've got it!
- jakaihammuda2 years agoHelper III
Do you know if the Native queries that are sent back to the source, utilise the DB's index functioning if it has indexing?
- Idrissshatila2 years agoSuper User
- jakaihammuda2 years agoHelper III
I understand, but just it utilise the databases indexing to retrieve the data quicker is my point?