Fix Salesforce Report 2000 Records Export Limit - Skyvia

Salesforce Report exports only 2000 records

Overview

When using Salesforce Reports as a data source in Skyvia, the export is limited to the first 2,000 rows. This is not a Skyvia limitation — it is a hard restriction imposed by the Salesforce Run Report API, which Skyvia uses to retrieve report data.

Why This Happens

Skyvia integrates with Salesforce via its API, inheriting both its features and limitations. The Run Report REST API returns a maximum of 2,000 rows per call and does not support pagination for report results. This limit applies regardless of the actual report size and cannot be overridden through Skyvia configuration.

Additional Resources

    • Related Articles

    • Salesforce API errors: TotalRequests Limit Exceeded / ApiBatchItems Limit Exceeded

      Overview The TotalRequests Limit Exceeded and ApiBatchItems Limit Exceeded errors are Salesforce-side governor limits. They are not related to Skyvia's own limits. When these limits are reached, Salesforce rejects all further API calls until the ...

    • Skyvia Backup Errors Caused by Salesforce API Requirements

      Overview Skyvia interacts with Salesforce via its API. During a backup or replication operation, you may encounter errors caused by certain limitations or behaviors specific to the Salesforce API. Why This Happens When Skyvia performs a backup or ...

    • Salesforce: Inactive User Error

      Overview The "inactive user" error occurs at the Salesforce connection level in Skyvia. It means that the Salesforce user account used for the connection is inactive or no longer valid, so Salesforce blocks API authentication. As a result, Skyvia ...

    • Freshdesk: The Limit of Freshdesk API Calls Per Hour Has Been Reached

      Overview This error occurs on the Freshdesk side and indicates that the hourly API call limit has been exceeded. Skyvia interacts with Freshdesk via its API, and depending on the API version and object type, a large number of API calls may be ...

    • UPDATED: Salesforce: Expired access/refresh token

      Overview If you see an "expired access/refresh token" error, your Salesforce OAuth connection is invalid. This happens when the token has expired, been revoked, or invalidated by a Salesforce security policy change. Possible Causes The OAuth token ...