Forum Discussion
How to enable query folding from a salesforce object
"Currently, “View Native Query” is greyed out even in the first steps of the query. This indicates query folding is not happening."
You would think that, but it is incorrect. Query folding is happening in some limited fashion, specifically for column selection and column filtering. Custom SOQL will be generated for some of the Power Query transforms. You can check this in the Power Query Diagnostics output - it will show the custom SOQL query HTTP call.
Since SOQL is quite different from SQL I think Microsoft decided not to use the term "Query Folding" and not to show the custom SOQL in the "View Native Query" part.
Note that the custom SOQL is limited to in-object queries. Relationship queries are not currently supported, so you cannot reproduce SFDC Report Types in Power BI just yet.
Super User"Currently, “View Native Query” is greyed out even in the first steps of the query. This indicates query folding is not happening."
You would think that, but it is incorrect. Query folding is happening in some limited fashion, specifically for column selection and column filtering. Custom SOQL will be generated for some of the Power Query transforms. You can check this in the Power Query Diagnostics output - it will show the custom SOQL query HTTP call.
Since SOQL is quite different from SQL I think Microsoft decided not to use the term "Query Folding" and not to show the custom SOQL in the "View Native Query" part.
Note that the custom SOQL is limited to in-object queries. Relationship queries are not currently supported, so you cannot reproduce SFDC Report Types in Power BI just yet.