Octane Odata feed data restriction

[Anonymous]

I am creating a powerbi report using Octane odata feed and trying to fetch test execution runs.The challenge I am facing is there is a data restriction of 2000 record can be fetched at a time and We need to filter the data based on any date field

When I tried to use below filter criteria it is fetching data if there is less than 2000 record with the date filter

But when I am trying to use below filter criteria it is not working though data between these 2 dates are less than 2000

where Range start and End are as below

Can any one please let me know if I am missing anything or there is any syntax error

[lbendlin]

You could use a really conservative filter (for example only pull one day) and then extrapolate your other pull intervals.  For example when the single day returns 200 results you can likely safely pull 5 days each, but if it returns 20 results then you could pull in groups of 50 days, etc.

I assume your ODATA source does not support pagination natively?