How can we improve Power BI?

Allow passing of paramaters to Salesforce Reports connections

Parameters can be added to Salesforce report URL as explained here:
http://pragmaticforce.blogspot.com/2011/08/passing-report-criteria-via-dynamic_9002.html

Search for "reportFilters" in the API doc here: https://resources.docs.salesforce.com/sfdc/pdf/salesforce_analytics_rest_api.pdf

This would allow us to limit individual queries to <2000 rows. I know we can't get around that limit, but by narrowing the focus of the report dynamically, I am able to workaround. Please make parameter passing possible in Power Query Salesforce Report connections. Doesn't have to be pretty. ;-)

40 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Juan Pablo Zuloaga commented  ·   ·  Flag as inappropriate

        There are a number of limits set by Salesforce on API calls for Salesforce Reports. It is reasonable to think Excel report can support more than 2,000 rows on a typical report. That is first roadblock to resolve. In addition to that, there are other limits such as user concurrency and number of API calls per hour.
        Ideally, Microsoft is able to discuss with Salesforce to understand how best to use this connection without reaching any limits and allowing Power Query and Power BI be utilized using Salesforce Reports data.

      • Dory Owen commented  ·   ·  Flag as inappropriate

        Misspelled parameters. (This UI on Edge is wrapping text at every third word. Disorienting...just me? Weird.) I've been able to build a standard report in SF and then add params to the URL to narrow results. But cannot get these params added via Power Query. It looks like the API can pass params. The trick is to provide some way for us to add them to Power Query M statement. Without this workaround the limit of 2000 rows makes this feature almost useless because one never knows if results are complete.

        Potentially, I could pull first 2000 rows sorted by ID, then pass ">LastID" and get the next 2000 rows. Or, just limit standard report to only one Account or Owner or Rep to ensure results are limited to small # of rows.

      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.