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
Hi Santotaku23
Adding one more option for anyone landing here from search. The Object connector workaround works but, as @EugeneLebedev pointed out, it gets painful fast - 100+ tables to navigate, hours-long previews.
Power BI Connector for Salesforce is a native AppExchange app installed directly inside your Salesforce org, no middleware service in the middle, that pulls Salesforce Reports as-is without the 2,000-row cap. So you keep the report logic you've already built (filters, groupings, joined reports) and just consume it in Power BI.
30-day free trial, docs at https://metricasoftware.com/, happy to do a quick demo if useful.
Cheers,
Metrica Team.