Forum Discussion
salesforce connectivity - 2000 lines restriction
Anonymous,
Based on Miguel’s response in this idea, the 2000 row limit is from Salesforce Report API but not from Power BI. You can share this feedback with Salesforce as this is fully in their control.
As a workaround for the above issue, you can use Salesforce Object connector in Power BI Desktop to pull all the rows from individual tables and recreate reports you’d like. The Object connector doesn’t have the 2000 row limit.
Regards,
Anonymous,
Based on Miguel’s response in this idea, the 2000 row limit is from Salesforce Report API but not from Power BI. You can share this feedback with Salesforce as this is fully in their control.
As a workaround for the above issue, you can use Salesforce Object connector in Power BI Desktop to pull all the rows from individual tables and recreate reports you’d like. The Object connector doesn’t have the 2000 row limit.
Regards,
Is there a way to limit the rows (fields) from the object when connecting directly to a Salesforce Object?
catcollectorHelper I
Anonymous Any chance you have a solution for this? We have pulled in a few objects, but there's due to large amounts of data PowerBI just keeps churning to return the results. If we can limit the number of records being returned, we can vet out visualizations first.
Hey!
Yeah, I have found a way to bypass this problem!
You can check it out here: https://community.powerbi.com/t5/Power-Query/How-to-Bypass-Salesforce-2000-Rows-Limitation/m-p/900109#M30809
Hope it is useful! =D
Hi, I have a question
is the salesforce obejct connetor the online service from salesforce?
If I try to access/load this datas it tooks hours.
Thanks in advance
Manuela
- metrica
Post Prodigy
Hi everyone,
The 2,000-row cap is still there. It comes from the Salesforce Reports API and Salesforce hasn't lifted it. The standard workaround - switching to the Object connector - does bypass the cap, but introduces two new problems that several people in this thread ran into and never got an answer for:
- you lose all the report-level logic you'd already built in Salesforce (filters, groupings, joined reports) and have to rebuild it from raw tables in Power Query
- the Object connector doesn't fold filters into SOQL, so on anything above ~100k rows it pulls the whole object into memory before filtering - which is why catcollector and manuelaschuster were seeing churn for hours
A third option worth knowing about is Power BI Connector for Salesforce on AppExchange. It sits between the two native paths: pulls Salesforce Reports as-is without the 2,000-row cap, and for Objects does server-side filtering - so you trim millions of rows down to what you need before they reach Power BI, instead of after.
30-day free trial, no card. Docs at https://metricasoftware.com/, and we're happy to walk through a quick demo on your own reports if useful - just reach out.
Cheers,
Metrica Team.
