R or Python would definitely be a good option. I’ve done a little web scraping with R and then extracted it to an Excel file. While I haven’t used R or Python as a datasource in Power BI - this is an option. So I would anticipate that a script could be built and then pasted into the PBI datasource.