Forum Discussion
web scraping from multiple pages using power query
Hi All, New in power query, trying to scrape data table with multi web pages. Googling but not having the matching results 1 st website https://www.chcl.mu/storage-guide/ let
...
Richard072120 Not sure what you have in mind, but I could connect to both pages and loaded both tables to an Excel sheet. See attached.
Or are you by any chance on a Mac? Because PQ on the Mac does not support connecting to the web.
- Riny_van_Eekelen, what I was trying to do , using power query to import all pages of the table on an excel sheet as there are page 1 , 2 3 and so on .
Using Windows 11 and office 365.Richard072120 OK, then you need to create a custom function that will pick-up all the individual pages. The attached file contains such a function (very basic though), and only for the first link.
Difficult to explain since you mention to be new to PQ. The site in the link below is a good starting point to learn PQ. When you get to Chapter 18, you'll learn about custom functions.
- Riny_van_Eekelen, yes exactly I was looking for, but I was struggling since I am trying to learn this technique However " The site in the link below is a good starting point to learn PQ. When you get to Chapter 18, you'll learn about custom functions." I d'ont see the link , can you resend it .
Thank you for support.
