# How to Scrape the Web Directly into Power BI (Free Template)

> Source: https://scrape.do/blog/power-bi-web-scraper/

Published: 2026-04-16 · Updated: 2026-04-16 · Authors: Bugrahan Saka · Categories: scraping-use-cases

80% of enterprise companies use Power BI to visualize data. Almost none of them use it to collect it.

We changed that. We embedded Scrape.do's IP-rotating API directly into Power Query and wrapped it into a ready-to-use `.pbix` template. Paste your URLs, hit refresh, and live web data flows straight into your dashboards. No Python, no third-party extensions. [Download the template here](/uploads/blog/scrapedo_web_scraper_template.pbix) and follow along.

## Step 1: Open the Engine Room and Authorize

Open the file in Power BI Desktop, then click **Transform data** on the Home ribbon. This opens the Power Query Editor. In the left-hand Queries pane, find the **`ScrapeDo_Sniper`** function and click **Advanced Editor**. Replace `"ENTER_YOUR_TOKEN_HERE"` with your Scrape.do API token and click **Done**. That's the authorization sorted. You won't need to touch it again.

## Step 2: Load Your Target URLs

In the Queries pane, click the **`Target_URLs`** table. On the right side, open the **Query Settings** panel and find the **Applied Steps** list. Click the gear icon ⚙️ next to the `Source` step (or double-click it). A table pops up. Delete the placeholder URLs, paste in your targets, and click **OK**.

## Step 3: Fire the Engine and Clean the Output

Power BI immediately sends those URLs through Scrape.do's proxy pool, bypassing anti-bot walls and downloading the raw HTML into the `HTML_Data` column. Dead pages and 5xx errors sneak in sometimes. Right-click the `HTML_Data` column header and select **Remove Errors** to drop them. What's left is a clean list of successfully scraped responses.

## Step 4: Extract the Data You Actually Need

The template uses Power Query's `Text.BetweenDelimiters` function to pull specific fields from the HTML. Tell it which tags bracket the data you want: to get the product title, extract everything between `<title>` and `</title>`. To get an Amazon price, set the boundaries to `class="a-price-whole">` and `<`. The function slices through the raw HTML and drops the result into a clean column.

Once your parameters are set, click **Close & Apply** and watch your data populate the visualizations.

## Ready to Break the Limits?

Web scraping without code, running inside the BI tool your team already uses.

[Download the Free Power BI Scraper Template Here](/uploads/blog/scrapedo_web_scraper_template.pbix)

Grab your Scrape.do token, fire up Power BI, and turn the entire internet into your personal database.