Forum Discussion

pabeader's avatar
pabeader
Post Patron
4 years ago

Automatic Page Refresh not working as expected

I have a report that is using Direct-Query data mode.  The option for Page refresh is available.  I can select what cycle I want the page to refresh and it works while I have the report open in Deskt...
Help Requested
pabeader's avatar
pabeader
Post Patron
4 years ago

Then why include it in the Report Server version of desktop?  If it isn't supposed to work, don't include it.

Icey's avatar
Icey
Community Support
4 years ago

Hi pabeader ,

 

Sorry to have caused you misunderstanding. But there is no conflict between Power BI Desktop (optimized for Power BI Report Server) supporting automatic page refresh and Power BI Report Server not supporting it.

 

For using Automatic Page Refresh in Power BI Report Server, there is a workaround - Setting Data Refresh in Trigger Mode. When the data source referenced by the report has changed (added, changed, or deleted), then the trigger condition is activated to allow the PBI report to refresh the data immediately and keep the PBI report data up to date. 

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • pabeader's avatar
    pabeader
    Post Patron
    4 years ago

    So, if I want to setup a Kiosk display, using the SQL trigger method will refresh the data.  Does it also refresh the report display?

     

    • Icey's avatar
      Icey
      Community Support
      4 years ago

      Hi pabeader ,

       

      No. It is needed to refresh the report page manually in this scenario. 

       

      For your requirement, there is another workaround. No need to set SQL trigger, just try to add an extension to auto refresh browser page, such as Power BI Auto Refresh.

      For Edge: Power BI Auto Refresh - Microsoft Edge Addons

      For Chrome: Auto Refresh PowerBI Report - Chrome Web Store (google.com)

       

      Here is an example:

       

       

       

      Best Regards,

      Icey

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • pabeader's avatar
        pabeader
        Post Patron
        4 years ago

        I tried using one of those, but since it refreshes the whole page, it is actually calling the report, over and over again.  instead of just refreshing the visuals.