Apex Code Development You need to sign in to do that
Don't have an account?
Jason Yeung 6 Increase number of records can be exported from Salesforce Reports API
Hi,
I have a Power BI report which imports data from a couple of Salesforce Reports. One of these reports have more than 2,000 records. When I tried to display the data, it would only grab the first 2,000 records of the report if there are more than 2,000 records.
I did some investigation and it appears that it's by design for Salesforce Reports. https://developer.salesforce.com/docs/atlas.en-us.api_analytics.meta/api_analytics/sforce_analytics_rest_api_limits_limitations.htm#:~:text=A%20list%20of%20up%20to%202%2C000%20instances%20of%20a%20report,1%2C200%20asynchronous%20requests%20per%20hour.
I was wondering is there a way to increase the number of records that can be imported to Power BI? Or is there a workaround on how to do this?
Jason
I have a Power BI report which imports data from a couple of Salesforce Reports. One of these reports have more than 2,000 records. When I tried to display the data, it would only grab the first 2,000 records of the report if there are more than 2,000 records.
I did some investigation and it appears that it's by design for Salesforce Reports. https://developer.salesforce.com/docs/atlas.en-us.api_analytics.meta/api_analytics/sforce_analytics_rest_api_limits_limitations.htm#:~:text=A%20list%20of%20up%20to%202%2C000%20instances%20of%20a%20report,1%2C200%20asynchronous%20requests%20per%20hour.
I was wondering is there a way to increase the number of records that can be imported to Power BI? Or is there a workaround on how to do this?
Jason
I did see the documentation link you provided and it is currently limitation with the platform.
Came across this idea https://ideas.salesforce.com/s/idea/a0B8W00000Gda98UAB/increase-the-analytics-rest-api-limit-of-2000-report-rows in which a customer provided below workaround which you might want to try:
"I have found out this workaround using Google Sheets (also explains how to connect it to Excel Power Query)https://community.powerbi.com/t5/Power-Query/How-to-Bypass-Salesforce-2000-Rows-Limitation/m-p/900109#M30809For some reason the Google Sheets add-on "Data Connector for Salesforce" does not have the 2000 limit in reports.If you need to connect to the sheet via API, there are more info here:https://developers.google.com/sheets/api/samples/reading"
I'd also recommend upvoting the idea so that salesforce product team can consider implementing it in coming releases.
If this information helps, please mark the answer as best. Thank you