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].
![](https://www.thedataschool.co.uk/content/images/2024/02/image-109.png)
Step 2. Navigate to Web.
![](https://www.thedataschool.co.uk/content/images/2024/02/image-111.png)
Step 3. Enter URL from a website you would like to scrape.
![](https://www.thedataschool.co.uk/content/images/2024/02/image-112.png)
![](https://www.thedataschool.co.uk/content/images/2024/02/image-114.png)
Example of a website to scrape.
![](https://www.thedataschool.co.uk/content/images/2024/02/image-113.png)
Step 4. Continue to connect
![](https://www.thedataschool.co.uk/content/images/2024/02/image-115.png)
Step 5. Now you have a dataset to work with. It is very likely you would need to clean it up.
![](https://www.thedataschool.co.uk/content/images/2024/02/image-116.png)