Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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...
Solved! Go to 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...
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.
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
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.
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 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.
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.
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?
@GilbertQ does it matter which method you use in the background to update the data ie. direct query or scheduled updates ?
Proud to be a Super User!
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...
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |