Forum Discussion
Auto Update PowerBI View
Hi,
I have developed the Report and pinned it to Dashboard.
I would like to project this on Big Screens. How can I auto refresh the view or Dashboard without clicking on Refresh icon?
Can I set the same auto refresh option for Report if I have projected the report on screen?
Thanks
Arun
I doubt there would be a built-in way to automatically refresh the dashboard view. However, to reload the dashboard web page in a certain interval, I think you can try Tab Auto Reload for FireFox.
- Install that Add-on and restart FF.
- Open one tab in FF, navigate to the dashboard.
- Schedule a reload interval
- Press F11 to switch to Full screen mode.
If you're not using FF, I think there're similar add-ons for other popular browsers.
15 Replies
- samdthompson
Memorable Member
Assuming they are informational only then via browser in full screen mode with onprem direct data connection and also a scheduled refresh as the direct connection only updates on demand ie when interacted with. We have ones working with Explorer, Chrome and Safari. All good solutions.
- aruntd77
Helper I
Thanks for the update.
Let me try your suggestion for call center dashboards. I will update you.
We have another situation:
Since we are using Large Screens with Touch enabled for CXO level and Sr Management, they will interact with dashboard. I was planning to use Windows 10 App for projecting the reports. The data source is SQL Server.
They wont be interacting with dashboard always, however we want the view refreshed every hour at least,
Could you please suggest best way forward for this scenario?
Thanks
Arun
- Eric_Zhang
Microsoft Employee
I doubt there would be a built-in way to automatically refresh the dashboard view. However, to reload the dashboard web page in a certain interval, I think you can try Tab Auto Reload for FireFox.
- Install that Add-on and restart FF.
- Open one tab in FF, navigate to the dashboard.
- Schedule a reload interval
- Press F11 to switch to Full screen mode.
If you're not using FF, I think there're similar add-ons for other popular browsers.
- PowerUser77Frequent Visitor
Is there still no native way to auto refresh a report and/or dashboard using direct query or import from SQL? SSRS has an auto fresh setting for their reports I'm looking for something like that. I know in direct query the data updates every 15 minutes and the "REFRESHED" time updates on the dashboard, but the actual data does not update.
Thank you.
- elliotdixon
Responsive Resident
Hi PowerUser77 - any direct query report will refresh every 15mins or whenever you interact with the dashboard / reports. The data should be updating then as well.
- aruntd77
Helper I
Dear friends,
I finally used Power BI Javascript library and embedded the report in SPA Web App and I could call refresh function using Javascript Timer. This is working as expected.
Thanks
Arun
- scottbellRegular Visitor
Is there still no solution for import dashboards?
E.g. I fullscreen my dashboard in the web or the windows app and it auto refreshes with my scheduled data refreshes?
Regards,
Scott
- elliotdixon
Responsive Resident
Hi scottbell I have kind of managed to solve this.
I have a powershell script (that a kind developer in my office helped find and created) that opens internet explorer and then cycles through the different power bi websites - refreshing them as needed.
Is working quite well on a few different computers we have around the country.
Starts when the computer starts and cycles through different dashboards every 10 minutes.
Instructions
Open Internet Explorer and go to the BI site and log in.
Save the username and password in internet explorer
1. place the .ps1 file on the Desktop 2. place the .cmd file in the startup folder (win + r and type shell:startup to open startup folder) This script will open an ie window cycling through PowerBI dashboardsCreate a .cmd file that runs (batch file)
PowerShell -Command "Set-ExecutionPolicy Unrestricted" >> "%TEMP%\StartupLog.txt" 2>&1 PowerShell -WindowStyle Hidden C:\Users\%USERNAME%\Desktop\BiScreenCycle.ps1 >> "%TEMP%\StartupLog.txt" 2>&1
Create a Powersheel .ps1 file called BiScreenCycle.ps1
$errorActionPreference = "stop" $urls = @( # enter your url here and delete this line # add a new line for each url you want to cycle through ) $sleepSec = 600 $urlIndex = 0 $ie = new-object -comObject "InternetExplorer.Application" $ie.silent = $true $ie.visible = $true $ie.theatermode = $true while($true) { $ie.navigate($urls[$urlIndex]) start-sleep -s $sleepSec $urlIndex = ($urlIndex + 1) % $urls.length }(sorry - cant work out how to upload the actual files)
good luck