Power BI Basics: Web Scraping 101

If you ever wanted to pull data directly from the websites, here is a quick guide how to do this with PowerBI's Power Query.

Step 1. Once you're in Power Query, navigate to [New Source].

Step 2. Navigate to Web.

Step 3. Enter URL from a website you would like to scrape.

Example of a website to scrape.

Step 4. Continue to connect

Step 5. Now you have a dataset to work with. It is very likely you would need to clean it up.

Author:
Justinas Aleksiejus
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab