Hi Sangoyita,
I see an issue was opened with support.
Pasting the issue content here:
10000 records is the limit set by Saas and cannot be increased.
If you are only seeing 2000 records then that may be an issue with the third party tool you are using.
The 10000 limit per page is set by SAAS to ensure not too much data is pulled in the ODATA connector
For building reports, we recommend that you use a reporting tool such as Power BI. Power BI renders the data faster using caching and offers better data
security and control.
Business intelligence tool recommended in the documentation for example: Microsoft Power BI or Tableau
Excel provides no convenient way to map the report users to the Clarity PPM users.
OData v4 is not supported by Tableau; it support only v2. Microsoft Power BI supports both.
https://docops.ca.com/ca-ppm-saas/15-6/en/administration/configure-the-data-warehouse-and-advanced-reporting/configure-odata-access-to-the-data-warehouse
Regards