cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
harshadsp
Post Patron
Post Patron

Live Stream Web URL data in PBI

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!

1 ACCEPTED SOLUTION
v-xjiin-msft
Solution Sage
Solution Sage

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.

View solution in original post

3 REPLIES 3
v-xjiin-msft
Solution Sage
Solution Sage

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.

View solution in original post

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.

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

 

Thanks!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.