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
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
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.
