Forum Discussion

mahawkins3's avatar
mahawkins3
Helper 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
Helper 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!

ttankka's avatar
ttankka
Frequent Visitor
8 years ago

I have been working on this problem for some time, have tried what you suggested and it works!.  I am running an on prem gateway to SQL server.  It is hard to believe that there is so much content about this subject, yet no clear communication on how it works.  

 

To summarize what mahawkins3 stated:  you have to pin the individual report visualization (graph, table, etc..) using

 

 pin instead of Pin Live Page for real-time updates to work.