Scrape data from multiple pages on a website with Power BI and Power Query

Scrape multiple pages

Have you come across a website that has data you need but it is presented in multiple pages? Downloading page by page can be frustrating and time consuming.

In this short video, I will show you how to iterate multiple pages on a website to import the data using Power BI.

Table of contents:

00:00 Intro
00:30 Explain the user case
01:30 Break down the URL
02:30 Get web data in Power BI
03:00 Add parameter to the web url
04:30 Test our function
05:30 Create a list of years in power query
06:00 Call the function
07:00 Load the all the data in Power BI

Watch the tutorial

Link to the resource mentioned

Link to the NFL site