can I scrape html from a web page to get the json data into power bi?

[mcorning]

i could swear i watched a powerbi video that showed scraping data from an html page. but i cannot find a trace of this capability on the powerbi web site. was i dreaming, do you think?

[Greg_Deckler]

You can do it in Excel or Power BI Desktop through Power Query, haven't seen it on the service yet.

[ashishrj]

@mcorning You can refer Power BI REST API

[andre]

@mcorning web page is one of the supported sources for Power Query.  So create a new Power Query using Web as a source to get started.

[jthralow]

I have been doing something similar to this.  I have scraped data with Mozenda and then used their REST API to send that data to Microsoft Power BI.  Here is a quick link to explain how the two can talk.

http://www.mozenda.com/api/

https://msdn.microsoft.com/en-us/library/dn877544.aspx

Setting Mozenda up on a schedule to scrape and publish with their REST API allows you to take any web data, structure it and graph it in real time.

Here is a little example I did pairing Mozenda and Microsoft's Power BI.

https://www.linkedin.com/pulse/mozenda-power-bi-geek-heaven-jon-thralow?trk=mp-reader-card