get data (products and prices) from a web site that have more than 1 page

[Anonymous]

I'm trying to get the product's data from a web site and I can do it only for one page, but this web site has more than 10 pages of products, so how can I get the 10 page's data?

Thank you!

[v-yuta-msft · Accepted solution]

@Anonymous ,

To scrapy multiple pages web data source, you need to do some coding using M language. I suggest you follow steps in the third-party blogs below:

https://www.sumproduct.com/thought/referencing-multi-page-data-from-a-web-site-with-a-single-url

https://www.myonlinetraininghub.com/scrape-data-multiple-web-pages-power-query

Community Support Team _ Jimmy Tao

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

[parry2k]

@Anonymous hope this video helps