Forum Discussion
Missing data from Salesforce Report
Hello,
I am attempting to create a report dashboard in PowerBI for salesforce. The data I am collecting from salesforce is over 2,000 rows which means that I am missing data in the table. Is there any way to expand how many rows Power BI can pull from a salesforce report, or is this restriction dictated by Salesforce?
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
6 Replies
Santotaku23 , Open power query and check, have you filtered any data, check for ant data filter step
I am a fairly new user, but I am fairly confident I am not filtering anything out.
From what I gathered from a previous solution there is a limitation with the salesforce reporting where it will only display the top 2000 rows unless you export the report. The original user in this post adjusted the scope of their data so that their report was pulling fewer rows, but I was hoping there may be another work around as I am looking to pull a larger historical set that has 40k+ rows.
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
It 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/
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.
