SAP Knowledge Base Article - Public

2882683 - "Query results exceeded row/column count limit" error in SAP Analytics Cloud

Symptom

The following error messages occur in SAP Analytics Cloud (SAC):

  • Query results exceeded the row count limit of <limit>. Please edit your query to acquire fewer
  • Query results exceeded the column count limit of <limit>. Please upload different data, or edit your query to acquire fewer columns.

Environment

SAP Analytics Cloud 2026.18.0

Reproducing the Issue

  1. Create a data model.
  2. Schedule an update.
  3. In Data Management under Data Timeline, observe the error message.

Cause

  • Data acquisition workflow has a set of limits and restrictions, depending on the data sources and content types (account model, new model, dataset). The error appears when the acquired data exceeds the limit.
  • Learn more about the row, column, and cell limits for different data acquisition types in the Help Guide: System Sizing, Tuning, and Limits.
 

Resolution

  • If the volume of data to be updated exceeds the supported limit, split the data into smaller batches and import each batch separately.

    • For example, apply a filter for parameter X and run the import. Then, modify the filter to exclude parameter X and import the remaining data. Repeat this process as required until all data has been imported.
  • To avoid this issue in the future, schedule imports more frequently and apply appropriate filters in the query scheduling settings. This reduces the volume of data processed by each import job and helps prevent the limit from being exceeded.

See Also

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

Keywords

Analytics Cloud; query; exceeded; edit; fewer; limit; limitation; data; model; import; SAC; maximum; story; stories; models; OData; row
, KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-PL , Planning , Known Error

Product

SAP Analytics Cloud 1.0