This question has been asked multiple times in forums, blogs and in Power BI community.
How can I refresh my Power BI report every min and show it on a TV full-screen?
This is a lovely scenario where you want to show Power BI report with metrics, business performances, team performances etc. on a public display. May be on a TV in a hallway or in Factory Control rooms!
But, how do I do this?
It’s quite simple to setup!
(1) Make sure your data is refresh-able live. Either through direct query to a supported source (SQL etc.) or live connection to Analysis services.
(2) In your report URL in Power BI Service, append ?chromeless=1
This setting will open your report in full screen mode.
(3) Download and install a Google Chrome Add-in – “Super Auto Refresh Plus”
https://chrome.google.com/webstore/detail/super-auto-refresh-plus/globgafddkdlnalejlkcpaefakkhkdoa
(4) Setup the Add-in to refresh your report page every X mins. You want 10 seconds? You are covered!
And you are set to go.
A simpler way to refresh your report page every min and show it on a display!
Questions?
-Ranbeer
(@ranbeerm)
Looking for a quick start on your next Power BI project? Book one of our top selling service packages.
Hi,
If I connect to my database using Direct query,
As far as I know, data using this method can be updated every 15 minutes.
Therefore, the component (super auto refresh pulse)can not provide up-to-date information at the minute level.
BR
Alon
Hi Alon, that’s true for a dashboard and not for a Power BI Report. Why don’t you give it a try and see yourself how this works in Power BI Report? We have done this several times and it works!
-Ranbeer
What about if we want to do the same thing when using mobile view?
This scenario is mostly for large displays like TV. Not sure how is this report being viewed on mobile. Mobile App should have this capability, may be restricted to iOS. Notifications/Alerts works best for mobile scenarios.
dear,
I installed google chrome on my Sony Bravia TV but I am now able to install the extension of auto refresh .
When I checked it seems that we can install the extensions only for Chrome desktop version.
What kind of license is necessary to publish on a TV ?
I thin that using the developer account is not a good idea, right ?
It’s necessary to buy a specific PRO licence to use on TV ?
What do you suggest about the licence ?
Tks !
Yea, we used a pro license on an unattended machine. You have a Pro license or Power BI Embedded (costlier) at your disposal.
I my data source is from google sheet but when I did as you instruct It doesn’t work for new data
Does Power BI support direct query to Google Sheet? If no, then this solution will not work.
How can I do this with multiple Report like a slide show? How can I do the authentication for the outside of network?
Hi Rahman, there are many plugins that can help you. Chrome Auto Tab etc.
Can I see my dashboard on tv without virtual machines?
you need an internet connection and a browser to load your power bi dashboard