Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to use query against Salesforce Object

Is there any way to query against the Salesforce data directly. Gone thru the documentation-  https://docs.microsoft.com/en-us/power-query/connectors/salesforceobjects Where it is quoted -  Known...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    Using the built-in salesforce connector, it is only possible to query data after importing the whole table in Power BI Desktop. There is a similar idea about adding salesforce query in Power BI , please vote it up.

     

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

     

    Best Regards,

    Dedmon Dai

DoryO's avatar
DoryO
Regular Visitor
6 years ago

No one has explained why Microsoft documentation for the Salesforce connector mentions using "Select Query advanced option" to limit columns. Is this a documentation error? Is this an OBDC feature not applicable to Salesforce connectors?

 

The Salesforce REST APIs allow for the parameters we need but Microsoft's connectors don't take advantage of that. So I see no way to limit rows or columns. It is too easy to exceed 2k row limit and even column limits in the initial "Get" before we can "transform".