SAP Knowledge Base Article - Public

2984169 - Error "Unable to load more than 80000 rows of data" when accessing an OData datasource in SAP Analytics Cloud (SAC)

Symptom

When accessing an Odata datasource in SAP Analytics Cloud, you get the error "Unable to load more than 80000 rows of data" even if the data being returned is less than 80000 records.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.20

Reproducing the Issue

  1. Create Odata connection to Odata datasource
  2. Attempt to Retrieve data

Cause

This error occurs if the Odata datasource being used does not support the $top or $skip methods.  SAC requires any Odata datasource to support those keywords.

Resolution

Use an Odata datasource that supports the $top and $skip methods

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0