- 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
SAP Analytics Cloud (SAC) 2018.21.3 and later
Reproducing the Issue
- Refresh a story with large data.
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.
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
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.
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