REST API pagination & filtering

[Anonymous]

Hi everybody,

It's my first time using a REST API as a data source and this is my situation:

1. Pagination: I've figured out how to use a parameter to loop through pages since each page allows only 500 rows. I've followed this blog https://adatis.co.uk/Loop-through-Multiple-Web-Pages-using-Power-Query/ and the pagination works pretty good. The only challenge now is that I need to have a dynamic table that has the right number of pages (maybe counting my records?) instead of what I have right which is a fixed number of pages.

2. Power BI limitation of importing 10,000 rows from an API call for Pro Users. I need to import around 250,000 rows and I'm trying to filter my data source on the query script so I can use multiple calls with less than 10,000 records each , for example:  https://source.com/api/v4/orders?carrier_name=fedex&per_page=500&page=
But the result does not change...Is it something that my developer has to give me permission to use as a filter? The parameters that I'm using are actual columns on my API so I'm not sure why it does not work. Is there another way of doing this?

Thank you!