Forum Discussion
Missing data from Salesforce Report
Hi Santotaku23 ，
The 2,000 rows of data restriction is not a Power Query connector limitation but a general Salesforce Reports API restriction. You can use the Salesforce Objects connector in Power BI Desktop to get the entire dataset.
You can get more details in the following links.
salesforce connectivity - 2000 lines restriction
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.How to Bypass Salesforce 2000 Rows Limitation
Best Regards
Helper VIt is a limitation from Salesforce. There are multiple ways of overcoming it.
You can use Salesforce Object connector which doesn't have this limitation. It is a bit inconvenient since your data there is segmented in 100+ different tables. It also sometimes takes ages to load the data. I used to wait for hours for a preview of my tables to load in Power Query.
Salesforce Reports connector allows you to extract oly 2000 rows though. However, you can work around this limitation using third-party tools. Here is the approach that I would recommend: https://vidi-corp.com/connect-salesforce-reports-to-power-bi/