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)
RE: Have Power BI accept a SOQL statement for a Salesforce Query
This is definitely needed!
RE: Have Power BI accept a SOQL statement for a Salesforce Query
Hi, It will be awesome to have this functionality in Power BI. Importing a million rows worth of data just to visualize a couple hundred rows is not a good Idea at all. When it comes to scheduled refreshing it takes forever and even incremental refresh won't work in this case.
RE: Have Power BI accept a SOQL statement for a Salesforce Query
Yes, please. SOQL would be sooo helpful to improve query performance.
RE: Have Power BI accept a SOQL statement for a Salesforce Query
SFDC Object connector in PowerBI is nearly unuseable performance-wise without this, since it seems like no query folding happens.
RE: Have Power BI accept a SOQL statement for a Salesforce Query
The fact that this is missing is preventing us from doing what we need as one of our objects is over the 100000 row limit without any kind of filtering of the data.
RE: Have Power BI accept a SOQL statement for a Salesforce Query
We are having to pull down entire SFDC tables, to only use and join data from this fiscal year. The query bloat is slowing things down significantly.
RE: Have Power BI accept a SOQL statement for a Salesforce Query
Please make this capability a reality! Beyond performance improvements it would dramatically simplify data set manipulation and join functionality.
RE: Have Power BI accept a SOQL statement for a Salesforce Query
This would really help us out because we could create custom SOQL that improve performance. We could include relationships between SalesForce Objects and limit data with WHERE clause.