Missing data from Salesforce Report

[Santotaku23]

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?

[EugeneLebedev]

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/

[amitchandak]

@Santotaku23 , Open power query and check, have you filtered any data, check for ant data filter step

[Santotaku23]

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. 

[Anonymous · Accepted solution]

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

[Santotaku23]

Thank you!

I defaulted to using the Salesforce Report option, but the Salesforce Object option works for me in my situation. It is a bit more challenging to navigate in my enviornment but it was able to work.