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: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