Power Query From Webpage Multiple Pages

[brent_milne]

I am trying to do a query on a webpage table that has multiple pages. Example - www.webpage.com/page=1, www.webpage.com/page=2, etc. Do I have to make a separate query for each page or is there an easier way to get the data returned from all the pages. The tables are all setup the same on each page but sometimes there might be 200 pages that I need to query. Thanks for any help with this.

 

[JustynaMK]

Hi,

You can turn your web query into a function. Once you load data for page=1, go to Power Query Editor, select your query and go to Advanced Editor. Modify the code as follows:

After you turn your query into a function, add a separate table with pageNumbers that you would like to call.

Go to Add Column > Invoke Custom Function >

This should successfully create Table results for each query. Click on any of the golden Table links to fully expand the results.

 

[brent_milne]

Thanks, this worked perfectly.

 

[JustynaMK]

you're most welcome.