2729600 - The data cannot be displayed ... error when refreshing a story with many widgets and/or data in SAP Analytics Cloud (SAC)

The following error occurs in SAP Analytics Cloud (SAC) when opening, refreshing or drilling down on dimension in a story with many widgets and/or a large amount of data:

• The data cannot be displayed because the query returned too many records. Please try filtering your data.
• The data cannot be displayed: the query process was stopped before it finished because it returned too many records. Please try filtering ... 

This error also appears in the browser developer tools HTTP archive (HAR) file trace:

• The selection returned more records than the limit in MaxResultRecords : The selection returned more records than the limit in MaxResultRecords : Number of data records exceeded
• The Cube that exceeds the limits contains the following dimensions : Rows:...
• The selection returned more records than the limit in MaxResultRecords : actual/query/default = .../1000000/1000000

• SAP Analytics Cloud (Enterprise)

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, 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, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, , KBA , live connection data cannot be displayed , drill limitation settings not working as , settings not working as expected for tab , table , table widgets , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-XUS , User assistance, performance statistics , LOD-ANA-TAB , Table , Problem