Power BI
DeclinedRemove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Greg Galloway on 25 Mar 2015 23:57:32
In Power Query in Excel and in the Designer, the current implementation of "From Salesforce Report" is useless due to the Salesforce 2000 row limitation. Please push them to raise that. And please figure out how internally inside Power Query you can retrieve the first 2000 rows, then the next 2000 rows, etc. to get all the rows.
Also please allow us to push filters to Salesforce so that the 2000 rows that are returned are from the date range we want. Allowing us to pass filters would let us iterate over a date table and run the report once for each day and then append the results, thus working around the 2000 row limit.
Administrator on 11 Aug 2016 00:11:15
Thanks everyone for your feedback - as much as we would *love* to remove this limitation, it is not a Power Query connector limitation but a general Salesforce Reports API restriction. Please make sure to share this feedback with Salesforce as this is fully in their control. In fact, once/if they remove this API limit, there wouldn’t be any product change required on the Power Query connector to pull the entire dataset, as there’s not any explicit limit defined on our side.
- Comments (27)
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
We could get around the 2000 row limit if PQ would pass parameters to the report. Here's an explanation of how parameters work: http://pragmaticforce.blogspot.com/2011/08/passing-report-criteria-via-dynamic_9002.html
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
I tried using the report connector for Salesforce because the object one is not working properly (times out, does not pull all data...) as mentioned in other threads.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Hi, Youi mention above "You can also use query parameters to only retrieve data for a specific date". Can you give us some guidance or a link as to how we would achieve this?
Thanks.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Surely if you use query parameters to retrieve values for a specific date, you will only be getting the filtered dates that are in the data in the returned 2000 rows. After all, the filtering is done on the client, not the server... Yes?
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
This makes me sad...
I have a store universe list of a few rows count shy of 9,000 that I need all! The work around defeat the purpose of me moving to use Power BI. I have a colleague using R Studio for merging many data sets from different sources so I guess I will try that next.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
This is a game changer for us - currently the 2,000 row limit on Reports renders the connection useless. Building through objects is very long winded and messy - definately not something your average end user could do.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Using the "From Salesforce Object" connector to pull individual tables will let you pull more than 2000 rows. Then you can join (merge in Power Query terms) multiple tables to recreate the structure of the report. It works but isn't convenient or easy.
That being said, the 2000 row limit makes the "From Salesforce Report" connector completely useless, so I still think you should work on this request even though there's a somewhat reasonable workaround.