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
Hey,
So during import mode, all data is imported into the report. Then are you saying that if the next 6 sequence of applied steps are Native Query enabled, then they will be rolled into one single query, then the remainder of applied steps will occur one by one?
Is that how it works in speeding up the process?
Or does it mean that when the report is refreshed, that all the Native Query steps are being sent in one query back to the DB during that refresh to gather what is required based on those Native Query steps?
Please bear in mind im only refrencing import mode.
Thank you 🙂
For import mode, when the report is refreshed PBI will query the DB with the native query that you see and if the query fold breaks after that, will apply the rest of the steps it needs after it brings the data in.
You can test this yourself, if you check the steps after each transformation.
This step is the navigation to the table.
If I want to take out some columns, the next step will show the query that it will run on refresh. In Power BI its a remove columns step but instead of getting everything and then deleting all the additional columns, it just simplifies the sql query.
Similarly, if I want only 2020 data and filter in Power BI - It folds all those steps into 1 query that will execute when refreshed. Which means less load that Power Query has to do!
I think you've got it!
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"?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?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.
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 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 isHi 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?