Category:Scraping Use Cases

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

2 Mins Read

Created Date: April 16, 2026

Updated Date: April 16, 2026

Bugrahan Saka

Growth

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