3506455 - Importing data from CDS query into SAC, then it is importing only 40000 rows in SAP Analytics Cloud (SAC).

When imported data into SAC then it is importing only 40000 rows, while more data is available in the query.

• SAP Analytics Cloud version 2024.8.20 
• Import BW connection

1. Login to SAC.
2. Go to Modeler.
3. Open the model.
4. Switch to Data Management.
5. Refresh the import job.
6. Notice that it is importing only 40000 data rows.

Note:

• More than 40,000 data rows are available in the query.
• When executing CDS query in the backend transaction RSRT then only 40,000 data rows are shown in the result.

Kindly implement the KBA 3404335 - Read access on BW InfoProvider fails with DBSQL_TOO_MANY_OPEN_CURSOR runtime error (Follow-up) - SAP for Me

• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
              
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today! 

import, cds, SAC, query, 40000, data, bw, rows, importing, rsrt , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem