How can we improve Power BI?

Have Power BI accept a SOQL statement for a Salesforce Query

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.

112 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

14 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Juan U. commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Ayush Nigam commented  ·   ·  Flag as inappropriate

    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.

  • Stephen Snyder commented  ·   ·  Flag as inappropriate

    SFDC Object connector in PowerBI is nearly unuseable performance-wise without this, since it seems like no query folding happens.

  • Tom commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please make this capability a reality! Beyond performance improvements it would dramatically simplify data set manipulation and join functionality.

  • Chris commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.