Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Have Power BI accept a SOQL statement for a Salesforce Query

    Vote (450) Share
    Jonathan Schlereth's profile image

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

    Rob on 06 Jul 2020 00:04:45

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

    sounds good

    Jonathan Schlereth's profile image Profile Picture

    Joab on 06 Jul 2020 00:02:39

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

    adding this would be interesting to extract the data!!!

    Jonathan Schlereth's profile image Profile Picture

    Christy on 05 Jul 2020 23:59:58

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

    Please add this! It would be a life saver!

    Jonathan Schlereth's profile image Profile Picture

    Victor Richardson on 05 Jul 2020 23:56:05

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

    Very much needed

    Jonathan Schlereth's profile image Profile Picture

    Alexus Wong on 05 Jul 2020 23:53:31

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

    would be super helpful

    Jonathan Schlereth's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:52:36

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

    Much needed functionality!

    Jonathan Schlereth's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:50:49

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

    Totaly Needed !!

    Jonathan Schlereth's profile image Profile Picture

    Juan U. on 05 Jul 2020 23:47:17

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

    Absolutely need this! Some tables have millions of rows as it pulling data from all 80 countries in which we have presence and dating all the way back to 2004.

    I only need this year, may last year, and I need the data separated by region/country.

    Jonathan Schlereth's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:34:46

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

    Been working with PowerBI + Salesforce for a couple of years and this is the most needed functionality in PowerBI. As stated below, the object connector is highly inefficient and prevents us to use PowerBI in many scenarios

    Jonathan Schlereth's profile image Profile Picture

    Neel on 05 Jul 2020 23:31:59

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

    This is definitely needed!