Forum Discussion
Salesforce Reporting row number Limitations
Anonymous,
The 2000 row limit is from Salesforce Report API but not from Power BI. You can contact Salesforce support about this row limit 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.
Regards,
Lydia
Anonymous,
The 2000 row limit is from Salesforce Report API but not from Power BI. You can contact Salesforce support about this row limit 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.
Regards,
Lydia
Anonymous I can't access SFDC tables directly due to company policy... Is there any other workaround where i can get connected to report and get complete data. I am expecting around 15K rows in my SFDC report.
I have the same problem. Is there any workaround?
Hello!
I have found a way to bypass this problem.
You can check it out here: https://community.powerbi.com/t5/Power-Query/How-to-Bypass-Salesforce-2000-Rows-Limitation/m-p/900109#M30809
Hope it is useful!
