Define limit parameter API call - import more than 10 rows of data

[rubenbet]

Hi all,

I'm looking to import Chargebee data by using their API. I've managed to connect to the API with basic authentication. At the moment I'm able to load 10 rows of data. Their API documentation is available here: Subscriptions | Chargebee API documentation.

In total there are about 8000 rows of data available and I would like to import them all (and keep the data up-to-date after). On the Chargebee website I found the following article: How to list more than 10 items when listing information via API? : Chargebee Help Center.

I've tried to input this in a query in a few variations, but I did not succeed.

My question is if someone can explain me how I can make this work in PowerBI. Thanks in advance for your help!