Live Stream Web URL data in PBI

[harshadsp]

Hello, 

I am not sure if we could do this in PBI. Say, I have a market data website https://markets.wsj.com/ and I want to live stream this data in my pbi report. So when any data changes in this website will be reflected in pbi report.

Earler I have created hybrid data sets which I could poplate data with custom API in python or .net code but not sure how to map this wbsite with libe streaming in pbi.

Could anyone please advise how to get this?

Thanks!

[v-xjiin-msft · Accepted solution]

Hi @harshadsp,

In your scenario, first we can use Get Data from Web option to import the data on this web site into Power BI.

Then for the refresh part. You should know that Power BI cannot refresh data automatically. So if you want to refresh data, two options: Click Refresh button or Configure a scheduled refresh.

Thanks,
Xi Jin.

[CatchSandeepVai]

but this is not live refresh. We can schedule max 8 times in a day so this mean it will get refreshed after every 3 hours and not live.

[harshadsp]

Thanks @v-xjiin-msft. It worked. I was not sure that PBI refesh will also refresh the web site.

Thanks!