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

(0) Share

Report

Posted on 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.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

lbendlin 8,372 Super User 2025 Season 2 on at

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

Was this reply helpful? Yes No
StevenHarrison 10 on at

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

Was this reply helpful? Yes No