API data Source connection - how to get all pages from URL request into Power BI dataset

Like (0) Share

Report

Posted on 10 Nov 2022 11:27:55 by StevenHarrison

Hi Guys - I have posted this also in the Power BI forum, but thought there may be a way (better way?) to do this using power automate:

I have been given credentials to query an API connection to return data.

The URL they have given me brings back 100 items from the parameter at the end of the string &page=1, so therefore just the first page.

https://eu-app.rantandrave.com/RapideIntegration/feedback-details?from=2021-01-06%2000:00:00%20&to=%...

Can you advise if it's possible through Power automate to increment the page number to request all the data, i.e. page 2, page 3 etc until all the data is returned?

Their API documentation is as below but their support desk does not know how to connect to Power BI

API documentation.JPG

Any thoughts/feedback very welcome.

All responses (2)

Answers (1)

StevenHarrison 10 on 14 Nov 2022 at 09:31:30

Like (0)

Report

Re: API data Source connection - how to get all pages from URL request into Power BI dataset

Thank you for the feedback, much appreciated @lbendlin
Verified answer

lbendlin 7,799 Super User 2025 Season 1 on 13 Nov 2022 at 19:44:19

Like (1)

Report

Re: API data Source connection - how to get all pages from URL request into Power BI dataset

This is likely much easier in Power BI. Read about web.contents pagination