Skip to main content

    Power BI

    Needs Votes

    Have Power BI accept a SOQL statement for a Salesforce Query

    Vote (190) Share
    's profile image

    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)
    's profile image Profile Picture

    45723ad1 1369-4b9d-aef1-e84bdb369ec6 on 05 Jul 2020 23:06:41

    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.

    's profile image Profile Picture

    869ab9d5 1a04-4068-8610-222b34763325 on 05 Jul 2020 22:48:17

    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.

    's profile image Profile Picture

    83a53055 ae97-47a2-b737-41bf364234c7 on 05 Jul 2020 22:47:30

    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.