Renato Medeiros on 10 Oct 2018 02:42:02
Hello.
I just found out that the Salesforce connector with Power BI Desktop has a 2000 rows limit. This is, unfortunately, frustanting. Howcome you guys say that Big data and analytics are the future topics of technology, if you can't connect to more than 2000 rows to a super imporant Datasource as Salesforce?
As you guys know, is it possible for Qlik View to connect Salesforce using the Object/Custom Objetct.
Please, fix this! There is no way Power BI can become the most used BI tool if this liimitation persist longer.
Thanks
- Comments (3)
RE: Salesforce 2000 Rows Limit and Custom Salesforce Object
yes it's a limitation of Power Query Salesforce Reports connector. similar kind of a connector is available in Google sheets as an add-on that addresses this problem. Many product api's come with this kind of limiation of allowing to read not more than x number of records in a single api call. It's upto the connector (like Salesforce report connector in Power Query or Salesforce data connector in Google Sheets) to do the recusive calls to the api until the last record is read through the api.Google addressed it in its Salesforce data connector of Google sheets. Microsoft hasn't addressed it yet in Power Query. Moreover, it's not a huge development effort for that enhancement of reading full report data. It is just about turning that api call into a recursive on until all records of the report are read.Does Microsoft really need votes for it? Prioritization doesn't necessarily had to be through votes all the time. Folks are posting solutions to extract full report data using google sheets and then consuming it into the power query from google drive using web api like here:Solved: How to Bypass Salesforce 2000 Rows Limitation - Microsoft Power BI CommunityThese are the loops that are driving people to see the alternate vendor solutions.same idea posted as another one here too: Microsoft Idea (powerbi.com)
RE: Salesforce 2000 Rows Limit and Custom Salesforce Object
Is 2000 rows still the limit?
RE: Salesforce 2000 Rows Limit and Custom Salesforce Object
I went through the same problem and one solution was to use the objects.
I really want the reports to go from 2000 to infinity. It would take 100% of the data that gets heavy.