Forum Discussion
Solved
PowerBi relative path pagination
Hi, I have a little problem with my dataset refreshing in PowerBi service. My dataset is from an API with pagination. Below my link: Bron = Json.Document(Web.Contents("https://app.website.n...
Query = [page = Number.ToText(page)],
The example where you got the first 10 page works, but how do I get all the pages instead of 10?
Im not sure how many pages there are.
Check the API documentation. Is there a way to see how many pages or total items there are? If yes, you can then figure out how to dynamically construct the input list of pages ahead of time, which should run faster.
The alternative is the method you are trying in your other post, where you make the web calls until you get a bad response. You are on the right track and overall looks good.
I think the one problem you are running into is that your Query record in fSales does not look correct:
What you have now:
Query = [page = "&Number.ToText(page)"]
What it should be:
Query = [page = Number.ToText(page)]