I Am using odata to pull some table data on my DW. When i am using the direct odata connector on Tableau, it's giving me all rows. When i am calling the api through Postman or python script, its limiting number to 2000, is there a way to use pagination to pull entire data.
Example of URL i am trying to call:
I have attached the code also on what python code i am using to call the api.
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 datasecurity 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.