'Is there a way to direct query Salesforce Objects to Power Query/Power BI without having to extract the object
My data lives in Salesforce objects and I am trying to connect Power Query to Salesforce Objects. The limitation here is that I have to extract the whole object and then filter the required fields. Is there an option to direct query salesforce object without having to extract the object.
Solution 1:[1]
No, for SalesForce objects or reports you can't use direct query. The full list of data sources you can or can't use direct query against, see the page at the MS Docs website:
https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
Solution 2:[2]
it should be possible if you use a third-party connector where you can query fields such as:
Account
Lead
Contact
Task
Opportunity
Campaign
these should be the fields that are possible to request from salesforce REST API.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Jon |
| Solution 2 | Pushkin |