Forum Discussion
salesforce connectivity - 2000 lines restriction
Hi, Is there any solution to ensure ALL the rows in salesforce appear in power BI? Currently the restriction is 2000 rows. I understand from earlier responses and searches that this is a Sale...
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,
You can upvote the request to increase that 2000-row limitation. The more votes, the more likely it will be changed. Here is that link. https://ideas.salesforce.com/s/idea/a0B8W00000GdYvXUAV/power-bi-communicate-with-microsoft-development-team