cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pabeader
Helper V
Helper V

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 Desktop.  After I upload it to the Report Server, it doesn't autorefresh the page.

Is there something I'm missing to make this work?

 

7 REPLIES 7
tsql_simon
Advocate I
Advocate I

Hi,

 

I am having the same issue, it odd its available in the PBIRS Desktop client but not working when published, not sure if that is by design or simply not fully implemented yet 😪

FarhanAhmed
Super User
Super User

I am not sure if this option is available for PBIRS

 

Ref: Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs

 

FarhanAhmed_0-1634097358110.png

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




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

Icey
Community Support
Community Support

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.

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
Community Support
Community Support

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:

auto page refresh.gif

 

 

 

Best Regards,

Icey

 

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

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.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!