Web scraping with Power Bi

[Anonymous]

Hello all,

Is it possible for webscraping with Power bi? I mean in a website on doing a click on particular button gives some data. So, command we give from power bi should click on the button and get data from website which shoould be done fequently using automation

[v-diye-msft · Accepted solution]

HI @Anonymous 

Sure, Please kindly refer to below link:

https://www.youtube.com/watch?v=RnMrGaiVWtQ 

This is made to power query in excel but it also works in power bi:

https://www.mattmasson.com/2014/11/iterating-over-multiple-pages-of-web-data-using-power-query/ 

Official document also be your reference:

https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example 

[Do5779]

I have the same problem, but the link (

https://www.mattmasson.com/2014/11/iterating-over-multiple-pages-of-web-data-using-power-query/)

 does not work anymore.

Do you or someone have another idea? The solution to load the table by examples has not worked either.

😐

[dethompson97]

Yes, you can bring data into Power BI from a web source.  Here are some links that might help:

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-importing-and-analyzing-data-from-a-web-p...

https://www.youtube.com/watch?v=s_5Jk8_fHjA

Thanks!

Dawn