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
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.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
this is totally unreasonalbe to have this limit 2000 rows from salesforce.
Can someone to resolve this issue? Thank you!
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
This 2000 limit does not exist in Tableau. Someone in Microsoft Power BI team needs to address this as this limitation does not exist in a direct competitor. Can someone please address the recent comments below? Thank you!
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
I have same problem with salesforce report using powerbi... , what should i do now?
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
Hello.
Any new about this issue?
Power Bi it is a really great tools, but 2000 lines make me sad.
I hope you will find the solution ASAP.
Thanks in advance.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
I talked to SF and this is what they say: We do offer our SOAP and REST API as well, which allows for retrieving larger datasets, however PowerBI is not using this. In my opinion this is therefore a PowerBI issue, as they have created this connection with the wrong API.
Could you guys please fix this!
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
If this is a Salesforce problem why is it working with Tableau? PowerBI needs to fix this in order to make it a useful tool.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
I completely agree. I am a Salesforce CRM admin, and I was really excited when I heard that you could connect to your Salesforce reports in Power BI. Great, this sounded really fantastic since I thought we could keep track on parameters such as visit frequency, assessments etc. The row limitation of 2000 is absolutely insane, makes it completely useless. I am trying to get my head around why you would even promote that you can connect to your salesforce reports. I am deeply dissapointed and right now, I do not know whether I should become a Power BI PRO user or not.
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
This is great attitude - a product asks its users to talk with another product. Why Power BI cannot take the responsibility to make its feature really useful?
RE: Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce
This is pure laziness on Microsoft's part ("not our problem talk to Salesforce").
It was foolish to use the reporting API knowing it only returns 2000 rows - it's function is for on-screen display for reporting.
Surely Microsoft is able to work with other Salesforce APIs and come up with UI that generates SOQL to retrieve data from Salesforce Objects.
Weak