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: 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. ;-)
Richard Morgan commented
Yes please, pretty isn't important, but please expose more options.
Juan Pablo Zuloaga commented
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
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.