Forum Discussion

Helper I

5 years ago

Solved

Incremental Refresh with SalesForce

We are trying to set up incremental refresh. Our data is coming from SalesForce. We understand we need two key items: Data/Time column (Not a problem as we have a created and modified columns availab...

Need Help

Tutorial Requests

v-henryk-mstf
5 years ago
Hi dsimpsontx ,

Query folding for Salesforce objects is not currently indicated through the View Native Query, you can see it when you run diagnostics on your Power Query transformation step.

You can refer to similar solutions for details, I hope it will help you.

Solved: Re: Power BI connected to Salesforce datasource - ... - Microsoft Power BI Community

Solved: How to enable query folding from a salesforce obje... - Microsoft Power BI Community

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf

Community Support

5 years ago

Hi dsimpsontx ,

For your description, the idea behind query folding is to push the logic built into the Power BI query back to the data source server, and then execute the logic in its native language instead of client-side conversion of the data.

After clicking it, it shows the native SQL statement that satisfies the query folding rules. If a conversion that does not support query folding is introduced, such as capitalizing each word, then the native query option is disabled.