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

    0a214ed4 16cc-4085-9a50-6fd724f456ac on 05 Jul 2020 23:52:36

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

    Much needed functionality!

    's profile image Profile Picture

    c903427e f47b-4d9f-aec3-9659c0ce6a8f on 05 Jul 2020 23:50:49

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

    Totaly Needed !!

    's profile image Profile Picture

    4379915f 19f4-4f0f-a721-d2928ec3362a 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.

    's profile image Profile Picture

    19b1c655 16c2-4160-8ae7-07e0d20a171b 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

    's profile image Profile Picture

    d451cef4 20b0-459a-8ad1-85ddc6f80061 on 05 Jul 2020 23:31:59

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

    This is definitely needed!

    's profile image Profile Picture

    3d302b9a c776-43c1-ae1e-bbd6ad096fd5 on 05 Jul 2020 23:31:56

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

    This is definitely needed!

    's profile image Profile Picture

    5e4c7224 e1db-435a-8021-7c04c623b52d on 05 Jul 2020 23:29:50

    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.

    's profile image Profile Picture

    0672b7dc 3885-4671-ac9e-01401f940921 on 05 Jul 2020 23:24:28

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

    Yes, please. SOQL would be sooo helpful to improve query performance.

    's profile image Profile Picture

    ad3c27d7 506e-4614-9976-beb335931517 on 05 Jul 2020 23:10:18

    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.

    's profile image Profile Picture

    d64829bb ac26-4ef0-8758-0c7f2425c393 on 05 Jul 2020 23:07:59

    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.