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.

lbendlin's avatar
lbendlin
Super User
2 years ago
I am missing something, How am i supposed to keep the data for the next day ?

 

You could take a risk and self reference your semantic model for that. Personally I would rather store my snapshots in a safe place.

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.