Imke Feldmann explains how you can perform paging with Power Query:
When you use an API with a paging mechanism (like the example from this blogpost), you’ll might work with a field that contains the address for the next page. You can use this to walk through the available chunks until you reach the last element. That last element in the pagination will not contain a next-field or that field will be null.
There is a bit of nuance to this, so click through and learn how.