SAP Knowledge Base Article - Public

3008366 - OData based Model imports only first 1000 rows in SAP Analytics Cloud (SAC)


The following behavior occurs in SAP Analytics Cloud (SAC):

  • OData based Import Data Connection retrieves only the first 1000  (one thousand) rows


  • SAP Analytics Cloud (Enterprise) 2021.2.0
  • OData 4.0 with @odata.nextlink functionality

Reproducing the Issue

  1. Create an Import Data Connection - OData, based on
  2. Select the Query named: Order_Details_Extendeds  (this query returns 1480 rows and has @odata.nextlink functionality)
  3. Run the import, only 1000 rows are imported


This issue is currently under investigation by development.


  • This issue is currently under investigation by development.

  • Workaround: in the Import Settings, set Incremental Load:
    - Import Method: Append
    - Incremental Load: use a field that can determine an incremental load, in this example OrderId - Since last Import

See Also

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


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 , Model, Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0