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
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?
I think you've got it!
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?