Power BI

Declined

Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce

Vote (13)

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)

Comments (27)

71e827b6 f45e-4bd4-9520-5683b2130321 on 06 Jul 2020 00:12:44

RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce

Any update on this? Thanks

89960bc7 9b66-4643-be9b-afad62d64846 on 06 Jul 2020 00:07:43

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?

0520e698 53e9-4f40-9862-8e0f3adbad4b on 06 Jul 2020 00:04:16

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.

09de457f 48a9-4511-b0bf-577e50d101d5 on 05 Jul 2020 23:39:48

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.

12ccfc6f 7c4d-4219-a85c-8a1b028b010f on 05 Jul 2020 23:27:02

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!

e0c923c6 e4db-4e76-b75f-34354c28f574 on 05 Jul 2020 23:20:31

RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce

Any Update ?

9867f166 6702-4802-a848-08c4cc8aded8 on 05 Jul 2020 23:15:10

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?

e702e492 ea1d-41f0-9cab-d614965b04e2 on 05 Jul 2020 23:05:52

RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce

so it is a Microsoft limitation..

24217521 1eeb-4dd3-9723-96d498a37810 on 05 Jul 2020 23:00:36

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

aec5a292 00e7-4117-90fb-e70bb1f90efa on 05 Jul 2020 22:52:29

RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce

Agreed that this is nonsense and needs to be fixed. We user remedyforce for our helpdesk and we cannot run full historical reports on our ticket queue directly.

In case anyone is interested, our solution is to create multiple identical reports in salesforce with fixed date ranges (where I happen to know each one will return less than 2,000 rows) and we merge all the outputs. One day one of them will go over 2,000, so I have a report in Power BI that shows me the total rows returned by each one.

I know this is madness.