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.
SAP Knowledge Base Article - Preview