Query Folding Icons in Power Query

[jakaihammuda]

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 researching, im seeing microsofts documents contain little incons next to their applied steps? like so

Im struggling to understand how to apply these icons to my Power Query Editor. Im seeing lots on things regaridng Query Plan or Power Query online, but not too sure what those both are as i cant find those anywhere.

Thanks

[Syk · Accepted solution]

Unfortuntely, the indicators are only for Power Query Online meaning you won't see it in Power BI Desktop's Power Query Editor.

[jakaihammuda]

Do you know if the Native queries that are sent back to the source, utilise the DB's index functioning if it has indexing?

[Idrissshatila]

@jakaihammuda ,

it doesn't affect the database, it only sends a query to retreive data.

[jakaihammuda]

I understand, but just it utilise the databases indexing to retrieve the data quicker is my point?

[jakaihammuda]

This is incredibly helpful, thank you.

When you say " if the query fold breaks after that, will apply the rest of the steps it needs after it brings the data in" how will the query fold break as such? Because all the native queries are rolled into one and then sent back, how can it "break". or do you just mean the first step after the last native query step will be the "break"?

[Syk]

Honestly, I'm not 100% about this. In my example, if I wanted to index columns (which breaks query folding) after filtering my understanding is that it will still execute the last query in the last screenshot THEN perform the indexing.

[jakaihammuda]

I just tested "remove column" and "remove other columns" in my report and neither of those came up as native query...even though they should be?

Filtering it shows as native query. No idea why that is 

[Idrissshatila]

@jakaihammuda ,

the steps that supports query folding are sent back to be transformed in the source while other steps will be done in power query, all of this happens when you refresh the data.

[jakaihammuda]

What i dont understand is that how can query folding steps be applied after the data has refreshes, for import mode? If the data has finished refreshing and we now have that imported. Youre saying that the Report has to go back to the db to perform the query folding steps, even thought weve imported? I just dont get how that works/is plausable.

[Idrissshatila]

@jakaihammuda , every time you refresh the data, Power BI re-imports all the data again.