Forum Discussion

aruntd77's avatar
aruntd77
Icon for Helper I rankHelper I
10 years ago
Solved

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

  • aruntd77

    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.

    1. Install that Add-on and restart FF.
    2. Open one tab in FF, navigate to the dashboard.
    3. Schedule a reload interval
    4. 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's avatar
    samdthompson
    Icon for Memorable Member rankMemorable 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's avatar
      aruntd77
      Icon for Helper I rankHelper 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's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee

        aruntd77

        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.

        1. Install that Add-on and restart FF.
        2. Open one tab in FF, navigate to the dashboard.
        3. Schedule a reload interval
        4. 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.
  • PowerUser77's avatar
    PowerUser77
    Frequent 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's avatar
      elliotdixon
      Icon for Responsive Resident rankResponsive 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.

  • 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

    • scottbell's avatar
      scottbell
      Regular 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's avatar
        elliotdixon
        Icon for Responsive Resident rankResponsive 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 dashboards

        Create 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