Power BI Mini Master Class 1: Using a REST API as a data source

Get additional data from the web

You don’t have access to this lesson

Please register or sign in to access the course content.

The previous module covered retrieving a list of locations with their IDs from the UN database. The current goal is to filter these locations to focus on European Union countries using an API.

In this lesson, Power BI is used to import the EU country list from a webpage. The data is then merged with UN IDs and prepared for the next API call.

The next module will involve querying the API to get forecasted population data for the filtered list of EU countries, including handling pagination to ensure all data is retrieved.