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
- Create a data model.
- Schedule an update.
- 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
- System Sizing, Tuning, and Limits
- Updating and Scheduling Models
- KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- SAP Analytics Cloud Connection Guide
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support
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
SAP Knowledge Base Article - Public