Query data from one URL with multiple sub-pages

[Anonymous]

Hey guys!

I am still (very) new at PowerBI and hopefully you can help me with an issue I am having.

I want to query web data from an online shop that has multiple pages. However, when switching in between these pages the URL doesn't change at all which is why PowerBI is only scraping data from the first page - the first 20 products. How can I scrape the rest of the products as well?

Many thanks in advance!

Best Lena

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[amitchandak]

@Anonymous , refer if that can help

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

https://datachant.com/2016/06/27/cursor-based-pagination-power-query/