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 (49)
RE: Have Power BI accept a SOQL statement for a Salesforce Query
This is the part that is missing. There would be no need for 3rd party products if this was there.
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
RE: Have Power BI accept a SOQL statement for a Salesforce Query
We need this feature as built-in connector is slow.
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!
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!
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
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
RE: Have Power BI accept a SOQL statement for a Salesforce Query
Need some way to filter object data! Please!
RE: Have Power BI accept a SOQL statement for a Salesforce Query
please make this happen!! pretty please!
RE: Have Power BI accept a SOQL statement for a Salesforce Query
Hey Microsoft, please make this happen!