3513186 - CDS query view used in Analysis for Office: Result is limited to 40,000 lines

When running a CDS query view(technical name starting with 2C) in Analysis for Office, the result is limited to 40,000 lines (e.g. 40000 lines, 40 thousand lines) (while more data is available in the query). The similar symptom also happens in other tools including transaction RSRT, which is also documented in KBA 3480546.

• SAP S/4HANA
• CDS Embedded Analytics
• SAP Analysis for Microsoft Office

40000 rows, 40,000 rows, 40.000 rows, 40000, 20.000 rows, 20000 rows, 20,000 rows, 20.000 lines, 20000 lines, 20,000 lines, RSRT, truncated, AO, Analysis for Office, Analysis Office, limit, lines, cds , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , BI-RA-AO-XLA , Excel Addin , Problem