Forum Discussion
Power BI connected to Salesforce datasource - How to check if query folding is happening ?
yes, that's exactly what it means. Most simple filters are supported, some are transformed from relative to absolute. But anything more complex than that is not currently supported.
It's good enough for incremental refresh.
Community SupportHi Anonymous ,
If the View Native Query option is not enabled (greyed out), this is evidence that all query steps cannot be folded. However, it could mean that a subset of steps can still be folded. Working backwards from the last step, you can check each step to see if the View Native Query option is enabled. If this is the case, then you have learned where, in the sequence of steps, that query folding could no longer be achieved.
You could reference the document below to check if the transformations that can be query folded.
Transformations that can achieve folding
And this blog may help you as well.
- lbendlin
Super User
v-xuding-msft Query folding for Salesforce objects is not currently indicated through the View Native Query link. It can only be observed the way I described. Hopefully this will be improved in the future, together with custom SOQL query support including subqueries. That would finally give us the possibility to recreate ReportTypes in SOQL.