Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
@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/
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |