Forum Discussion
Scrape from multiple pages
a1979d
Please refer to the blog below:
Web Scraping 2: Scrape multiple pages at once and refresh in Power BI service – The BIccountantPaul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
a1979d
Please refer to the blog below:
Web Scraping 2: Scrape multiple pages at once and refresh in Power BI service – The BIccountant
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Hello Anonymous , I'm having an issue trying to scrape monthly liquor sales data from the following website:
http://www.barmart.net/ReportSelect1.aspx
The URL doesn't seem to change when new filters are used or when clicking through to page 2, 3, etc. There are seemingly hundreds of pages of data, but I've only been succesful in pulling the first 200 or so when dropping the URL into the Web Query in PBI Desktop. It appears that filtering for larger timeframes is not accounted for, but defaults back to the current month filter.
Can anyone please steer me in the right direction before I start going copy/pasta crazy? 🙂
Thank you,
Kevin