SAP Knowledge Base Article - Public

2549769 - Error: "Export failed: The data cannot be displayed because the query returned too many records..." when trying to export data in a table or chart from a story in SAC

Symptom

The following error occurs when trying to export data from a chart or table widget in a story in SAP Analytics Cloud (SAC): "Export failed: The data cannot be displayed because the query returned too many records. Please try filtering your data."

Environment

SAP Analytics Cloud.

Reproducing the Issue

  1. Login to SAC.
  2. Open a story including chart or table widget with data.
  3. Select the widget >> Click on the three dots (More Actions) >> Export.
  4. Fill in the required information and click Export.

>> Notice the following error "Export failed: The data cannot be displayed because the query returned too many records. Please try filtering your data." 

Cause

The number of cells exported exceeds the limitations of SAP Analytics Cloud documented in the online help: Export Chart and Table Data from Stories | SAP Help Portal (Please review the "Restrictions Specific to Scope and File Type" section)

Resolution

  • Add filters to reduce the number of cells exported.
  • Exceeding the maximum number of records is easier than expected when exporting a large number of columns since the total number of cells is calculated as the number of columns multiplied by the number of rows.

See Also

  • 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 an case for SAP Analytics Cloud?

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0