Forum Discussion

ZekO's avatar
ZekO
Frequent Visitor
2 years ago
Solved

Paginated REST API - Reduce number of requests and handling updated data

Hi everyone,   I am using a REST API with a paginated method to retreive data from a system handling all the loading/unloading activity at a wharehouse. The pagination is working fine, I am also a...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    2 years ago

    Incremental refresh won't help you with that as the partition ranges are managed automatically by the service. You can only choose between day, month, quarter or year.  

     

     

     

    I would instead use an external storage.

ZekO's avatar
ZekO
Frequent Visitor
2 years ago

Hi lbendlin 

 

Here is the model that I try to implement thanks to your insights :

 

Can I apply an incremental refresh to this case in order to have the following result

 

 

The parameters RangeStart and RangeEnd (parameters requested for the Incremental refresh in PowerBI) would be :

RangeStart = Last modified Date

RangeEnd = Timestamp of refresh

 

Is it tricky with a paginated REST API ?

 

Thank you

lbendlin's avatar
lbendlin
Super User
2 years ago

Incremental refresh won't help you with that as the partition ranges are managed automatically by the service. You can only choose between day, month, quarter or year.  

 

 

 

I would instead use an external storage.