Forum Discussion
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...
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...
15 Replies
- Hi there
What if you rather create a streaming dataset, that will stream to a dashboard that can then update in real-time?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.
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...
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.
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.
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.
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
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.
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.
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
The most straightforward solution is using a visual environment where a Power BI application can be running. For example, they (http://smartnmagic.com) produce Android stand-alone touchscreen wall displays where you can just run it. That would eliminate any hassle with third party apps, workarounds, etc.
