Power BI

Needs Votes

Have Power BI accept a SOQL statement for a Salesforce Query

Vote (190)

on 28 Apr 2017 02:32:15

Just as we can write a specific a SQL statement from SQL Server, it would be great to be able to write a SOQL statement from Salesforce objects.

Also, it would be great to be able to grab the underlying SOQL statements that generate specific Salesforce reports, so that the underlying report itself doesn't have to be maintained and the underlying SOQL in Power BI could "take over" and be modified accordingly.

Comments (23)

Comments (23)

c70720e3 f6d8-ea11-a813-000d3a9b112e on 07 Aug 2020 22:47:58

RE: Have Power BI accept a SOQL statement for a Salesforce Query

A simple SOQL query would return the results I need.

But Salesforce Reports do allow filtering in the URL using parameters that can narrow the report to under 2k rows on the fly without having to modify the actual report.
https://help.salesforce.com/articleView?id=reports_filter_url.htm&type=5

It looks like the Salesforce Reports REST API also allows filtering. Maybe Microsoft can take advantage of passing parameters.
https://developer.salesforce.com/docs/atlas.en-us.api_analytics.meta/api_analytics/sforce_analytics_rest_api_filter_reportdata.htm