Forum Discussion

mahawkins3's avatar
mahawkins3
Icon for Helper I rankHelper I
9 years ago
Solved

Report visuals not updating

Hi,   I've set up a report (using Direct Query on an Azure SQL database) and published it to Power BI Service. In the settings, I have scheduled it to refresh every 15 minutes, which I had assumed ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi mahawkins3,

     

    When you pin a live page from the report to a dashboard, there is a notification:

     

    "Pin live page enables changes to reports to appear in the dashboard tile when the page is refreshed."

     

     

    It means after the dataset is refreshed, we need to refresh the dashboard page which contains report live page to update data. If you want to refresh page automatically, you can try v-ljerr-msft's suggestion: Refresh Report in TV Mode  .

     

    Best Regards,
    Qiuyun Yu

mahawkins3's avatar
mahawkins3
Icon for Helper I rankHelper I
9 years ago

So, on further inspection, it updates automatically when I pin each individual visualisation as a dashboard tile, but does not update if I just pin the entire report as a dashboard. A bit of a strange system, but it seems to work now!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

this is so strange, i am having the same issue as you. So youa re saying that we need to pin each tab of the report as a "live" tile for it to update automatically? that means it will only update the dashboard view and not the report itself? why would microsoft implement it this way??

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 

     

    I understand your frustration. Sometimes you might want to keep your visuals in a report (and not pin them or even pin the report as a Live Page to a Dashboard) while also having them update in correlation to the dataset that is updating in the background - again, within a report, not a Dashboard. 

     

    I was trying to solve a similar problem by not only having the visuals update but by also having the report cycle through its tabs automatically (such as having to display a Power BI Report on a Production Floor, which my company and I are about to do).

     

    I found a nice solution from _picoloto43 on another Power BI Support Ticket, where he programatically made the report cycle through its own tabs via a Google Chrome Extension. I took his code and modified it to have the tabs also programatically refresh upon each page cycle. 

     

    Basically, you use Javascript to programatically click the User Interface's buttons in the Power BI Service. For instance, when you log into Power BI and open a report that you published, you will notice that there is a refresh button on the top ribbon of the UI. You can force a Google Chrome extension to auto-click that button for you.

     

    I have uploaded my version of the Chrome Extension on GitHub:

     

    https://github.com/DMiradakis/Power-BI-Real-Time-Slideshow

     

    If you wanted to, you could just take my extension and delete the lines of code pertaining to cycling through the tabs (on the file called "Content.js") and just leave the line that clicks the Refresh button.

     

    Hope this helps.