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:

Search for "reportFilters" in the API doc here:

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. ;-)

48 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

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


Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • 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.