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 (28)
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
administrators - are you sure there is no solution to this limitation and address this? how come google's salesforce data connector for google sheets doesn't have this limitation?Check the below information sources:Microsoft Idea (powerbi.com)https://glazeforce.wordpress.com/2016/03/29/workaround-to-2000-record-limits-in-report-analytics-api-salesforce/
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Any update on this? Thanks
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Has Power BI updated their API for Salesforce to the Salesforce BULK API?
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
This limit is ONLY because Power BI chooses to use the standard API rather than develop a power BI connector to the asynchronous Salesforce BULK API.
https://developer.salesforce.com/docs/atlas.en-us.api_analytics.meta/api_analytics/sforce_analytics_rest_api_limits_limitations.htm
Other BI tools use the bulk API to get all (Millions) of rows.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Yes I was considering power BI as our salesforce reporting solution , but it appears that I will have to take the data outside of salesforce to get a full dataset connected. That requires another level of security, storage, and setup. Microsoft needs to fix the data connector API issue. Until they do I am going to recommend that we Skip power BI.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
So... it's a Microsoft problem (to lazy to change from one to another API --> SF BULK API). They blame Salesforce, so nothing happens. Simple laze solution from my side: I will not longer investigate to use of powerBI for my company!
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Any Update ?
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Is there any update on this? When will it get resolved?
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
so it is a Microsoft limitation..
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Agree with all the above. This seems like complete oversight. Tools such as Antivia's DecisionPoint have no such limits. Additionally, DecisionPoint has fully interactive offline access, white-label capability and more interaction with the data visuals. www.antivia.com