Use Power BI to loop through multiple pages of an API
It's common that an API will give you the option to hit an endpoint with a parameter.
In this video we look at how you can loop through multiple pages with Power BI and Power Query, using the Fantasy Premier League API as an example.
The URLs used in the video are here:
https://fantasy.premierleague.com/api...
https://fantasy.premierleague.com/api...