Pagination query does not return as requested records

the result has 2677 ,but when i wanna got the 1000 to 1500 just return 91 records

@WJustHM this is a known issue with the API when loading results from some datasets. Using the developer tools in your browser, do you see the same behavior when you run the same query from the Dremio UI?

@ben The result is correct in browser,Exists only in code

hello @ben

How should i solve this problem

Best Regards

@WJustHM, if it is a physical dataset, you might try forgetting the metadata and reformatting, but this will effect downstream virtual datasets.

Could you share the profile for the job you are returning the results from?

@ben Sorry,The problem has always been,I don’t know why,Please

Best (41.4 KB)