New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

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

Scrape data from multiple pages on a website with Power BI Desktop - Power BI Tips & Tricks

Link to the resource mentioned

Link to the NFL site

Was this helpful?
Next Scrape an image from a website using Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents