Power BI

Needs Votes

Have Power BI accept a SOQL statement for a Salesforce Query

Vote (447)

Jonathan Schlereth 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 (48)

Comments (48)

Ketan Patil on 24 Sep 2021 18:54:37

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

Salesforce object connector in Power BI is not well equipped to handle long string queries and it fails. Tried this option given in this link however this is really limited in its approach-> https://social.technet.microsoft.com/Forums/en-US/5abe0a7e-1894-4437-b5c3-75e24bdb5017/how-can-i-query-a-salesforce-object-to-return-only-specific-fields-columns?forum=powerquery

Ketan Patil on 01 Sep 2021 07:25:27

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

We need this feature as built-in connector is slow.

Kevin Partington on 20 Aug 2021 20:06:48

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

Please add this!

I'm currently trying to build reports on 130k Cases, along with related Accounts, Contacts, and Case History, and I cannot filter any of the tables. I have 5 million accounts and 12 million contacts, the vast majority of which I don't even need. And I can't even pull Case History without a timeout from the Salesforce API.

Using SOQL would make life SO much easier and make our refreshes many times faster!

Luke Moore on 11 Jun 2021 07:46:05

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

This would make accessing data SO much faster.
The built in connector is so slow - it is a royal pain in the proverbial!

Paul Ledington on 09 Jun 2021 04:31:27

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

Being able to use SOQl would make life so much easier, please add this

Dory Owen 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