SAP Knowledge Base Article - Public

2729600 - Error:"The data cannot be displayed because the query returned too many records. Please try filtering your data" occurs when refreshing large data story on SAC

Symptom

  • Error:"The data cannot be displayed because the query returned too many records. Please try filtering your data" occurs when refreshing large data story
  • Is there data maximum restriction for Live Data Connection on SAC

Environment

  • SAP Analytics Cloud (SAC) 2018.21.3 and later

Reproducing the Issue

  1. Logon SAC.
  2. Refresh a story with large data.

Resolution

Table and charts in SAC is used to analyze data, it is not for a Data Explorter purpose.

Data Explorter purpose is suggested to be done by Database Client tool.

So we recommand to limit records in the table, lower than 100,000 cells. In practice, a larger table does not perform well, it may also result in browser performance issue. Though the limit of records (rows and/or columns) can be adjusted in different client machine , if there are too many records from the query, the error may return from server side, or result in browser performance issue.

Moveover, the server and memory usage is not only related to the number of cells in table, the columns of field, the elemented used in table, the design of the table are also related. As a result, there is no exact limitation on cells in table or from data connection. But recommend to have lower than 100,000 cells.

It is recommended to add filters or reduce number of dimensions in the table to return less records.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

data maximum restriction, limitation, large amount of data, crosstab, data view, SAC story, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0