SAP Knowledge Base Article - Preview

3685484 - Incomplete data import from OData service in SAP Analytics Cloud (Total rows vs Imported rows mismatch)

Symptom

  • Attempting to run an Import Job using an OData Services connection, the job logs indicate a specific total number of rows (e.g., 'Total: 14,353 lines'). 
  • The job finishes successfully; however, only a small subset of the data is actually added to the model (e.g., 'Transaction records added to model: 2,000 lines').
  • When checking the job details, the Rejected Rows count is 0.
  • This issue occurs when using a large Batch Size (e.g., 50,000) in the query settings.
  • If you are facing issues where the same query runs several times with different results, please follow this guide:
    • 2816755 - - Inconsistent results while importing data using an OData service in SAP Analytics Cloud


Read more...

Environment

SAP Analytics Cloud Enterprise 2025.



 

Product

SAP Analytics Cloud all versions

Keywords

SAC, SAP Analytics Cloud, OData, Import, Missing Data, Rows, Pagination, Batch Size, nextLink, skiptoken, truncated, incomplete load, records added. , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.