cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
autodafe
Resolver I
Resolver I

How To Display on a TV?

One of my customers has created a report which is displayed on a full screen TV hosted on production line

The Report has a SQL Server Direct Connection (they have manufacturing machines that write data in SQL every few seconds...)

 

He needs the report to auto-update every 30 seconds to show near real-time information about production

 

At the moment he is using Chrome as browser, with a 3rd party extension to "auto-refresh" every 30 seconds.

Is there an option in PowerBI Service to automatcally refresh to see "live" data? (I know about scheduled refresh and auto-update from SSAS). I am talking about auto-refresh from SQL Direct Connection...

1 ACCEPTED SOLUTION

@autodafe I am only aware of the 3rd party way to force a refresh of the browser. This refresh initiates another query to the source database. The only option I know of that will automatically change data in the browser is when you are using Real Time streaming...


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

14 REPLIES 14
DMiradakis
Advocate I
Advocate I

Hey @autodafe and anyone else who might be interested,

 

I'm actually building a product right now to do just this. I think it's better than any alternative out there, and I've built one of the most popular of those alternatives, the open source Chrome extension Power BI Real-Time Slideshow  on GitHub. However, my extension is extremely prone to breaking due to it being a Javascript/HTML autoclicker, and I felt that I could build something far superiour that can solve the same problems.

 

Check it out, it's called Displagent: https://www.displagent.io

 

I would love if you would navigate to the bottom of the page and submit your email in the newsletter box.

 

If you still need these problems solved, Displagent can do it! 😁

 

Thanks!

-Daniel

Anonymous
Not applicable

I do have a solution but its a bit of a workaround. It uses the same concept as the chrome extension but uses javascript instead. Basically you need to embed the power bi report and have the javascript load the refreshed report behind the scenes. Once the new report is loaded, the script would swap out the new refreshed report with the old one.  Note, this script is still bugging, needs a bit of work.

 

https://stackoverflow.com/questions/57047846/remove-flickering-when-loading-power-bi-report-in-a-ifr...

http://codecorner.galanter.net/2016/05/05/flicker-free-iframe-refresh/

 

Also, you can use Power Bi live Stream but you will limited on the visuals you can use. 

https://www.youtube.com/watch?v=0YIBHfgasok&t=19s

Anonymous
Not applicable

I do have a solution but its a bit of a workaround. It uses the same concept as the chrome extension but uses javascript instead. Basically you need to embed the power bi report and have the javavscript load the refreshed report behind the scenes. Once the new report is loaded, the script would swap out the new refreshed report with the old one.  Note, this script is still bugging, needs a bit of work.

 

https://stackoverflow.com/questions/57047846/remove-flickering-when-loading-power-bi-report-in-a-ifr...

http://codecorner.galanter.net/2016/05/05/flicker-free-iframe-refresh/

 

Also, you can use Power Bi live Stream but you will limited on the visuals you can use. 

https://www.youtube.com/watch?v=0YIBHfgasok&t=19s

 

Anonymous
Not applicable

I do have a solution but its a bit of a workaround. It uses the same concept as the chrome extension but uses javascript instead. Basically you need to embed the power bi report and have the javavscript load the refreshed report behind the scenes. Once the new report is loaded, the script would swap out the new refreshed report with the old one.  Note, this script is still bugging, needs a bit of work.

 

https://stackoverflow.com/questions/57047846/remove-flickering-when-loading-power-bi-report-in-a-ifr...

http://codecorner.galanter.net/2016/05/05/flicker-free-iframe-refresh/

 

Also, you can use Power Bi live Stream but you will limited on the visuals you can use. 

https://www.youtube.com/watch?v=0YIBHfgasok&t=19s

GilbertQ
Super User
Super User

Hi there

What if you rather create a streaming dataset, that will stream to a dashboard that can then update in real-time?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hello i did'nt mean to intrude but i have the same concern but differently. I need to display on tv some data which is not mine, i work in my job with different areas at least four ones.  So they have their only exclusive data and we agreed all of us to share one dash board each, the problem is first off i need to dash board in one panel every data and display it on tv stream thus everytime they update their data. I created a work space where they can share their data to me and in my case create the dash board of all of them. Honesty i do not have any idea to stream the data to be honest. 

Hi there

It would appear that it would need more details around the exact requirements in terms of how often the data must be updated.

And possibly if they are using different logins for each TV you could look at Row Level Security.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I forgot my boss idea is to see the dash board like a video or just like a power point moving across every page. So im gonna have at least five or more different dash boards of several areas in one presentacion like video moving across every one.

Hi there

 

What you can do is to have each dashboard and then use a Google Add In like Revolver which scrolls through alll the open tabs.

 

This can all be running at full screen so that it moves thorugh them each and every time on a defined schedule?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ  does it matter which method you use in the background to update the data ie. direct query or scheduled updates ?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Hi there,

As long as you are refreshing the URL each time you hit the page, it should reload the data being shown




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thank you pal for your suporting i have found a solution using a programm named dashboard rotator is simple to use and practical. All i need to do is to paste every url on that programm and it does the rest. Have a good day. 

Hello there. Every area here have their own source some from sql others from excel, they update their data at least two times per day,morning and at the end of the day. In my case i need the data fresh on tv no matter the time they updated their data. So i created a panel where they can publish their data. But to have it fresh on tv i do not have any idea. What can i do? 

@autodafe I am only aware of the 3rd party way to force a refresh of the browser. This refresh initiates another query to the source database. The only option I know of that will automatically change data in the browser is when you are using Real Time streaming...


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors