Forum Discussion
Is Query Folding supported in PowerBI services - Dataflow?
Is Query Folding supported in PowerBI services - Dataflow?
Unlike power bi desktop, there is view native query to confirm if the steps are query folded.
In PBI service - dataflow, I cannot find the option 'view native query' after right clicked on the step. Do it mean query folding is not supported in dataflow?
Hi TK_FPA
Query folding is available in dataflow. "View data source query" is nothing but the native query. You can see the icon of the step and understand whether query folding is happenning or not.
In the below screenshot, first step is folded but not the 2nd step.
Refer - https://docs.microsoft.com/en-us/power-query/step-folding-indicators
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
2 Replies
Hi TK_FPA
Query folding is available in dataflow. "View data source query" is nothing but the native query. You can see the icon of the step and understand whether query folding is happenning or not.
In the below screenshot, first step is folded but not the 2nd step.
Refer - https://docs.microsoft.com/en-us/power-query/step-folding-indicators
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My LinkedinHi TK_FPA ，
A new dataflows connector was announced in the August 2021 release of Power BI Desktop, and that it now supports query folding between a dataset and a dataflow – which you may be surprised to learn was not possible before.
So whether dataflow supports query folding or not depends on the connector you are using.
To learn more details ,refer:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
