Scrape a Table from a Web Page in Power Query M

Extracts an HTML table from a web page's URL using Power Query's Web connector.

File HandlingIntermediateweb scrapinghtml tableconnector

Power Query M code

let
    Source = Web.Page(Web.Contents("https://example.com/data-page")),
    TargetTable = Source{0}[Data]
in
    TargetTable

Notes

Change the index in Source{0} to pick a different table if the page contains more than one.

Requirements

A public web page containing an HTML table.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Scrape a Table from a Web Page.