Extracting multiple tabs from single URL

Hi Bogle_SA1,

You can try the web connector in Power Query.

1.Open Power Query and navigate to the Data tab.
2.Click on Get Data and select From Web.
3.In the From Web dialog box, enter the URL of the webpage you want to extract data from.
4.Once the webpage loads, you will be presented with a preview of the data available on the page.
5.To extract a specific table, select it from the preview and click on Load1.
6.Repeat steps 3-5 for each table you want to extract.

Reference:

Power Query Web connector - Power Query | Microsoft Learn

For more complex data scraping, you can also try this feature: Get webpage data by providing examples.

Reference:

Extract data from a Web page by example - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.