Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
ziggedzh
New Member

Update powerbi in browser without having to press f5 to refresh.

I have a powerbi-report running in a browser on a wall-mounted TV, but I'm not sure how to update it without having to press "f5" to refresh.

Use Case:

We are creating a dashboard that displays how well a department is doing. Each department needs to log into the dashboard and see their particular data; they should not be able to view the performance of the other departments. The dashboard will be displayed 24/7 on a wall-mounted television. The data is refreshed every 2 hours.

Implementation:

Each department can access their part of the dashboard using row-level-security, and the dashboard is accessed through a web URL. We are using the "import" function to get data from our SQL-database. 

Problem:

The problem is that the web UI needs to be refreshed (F5) every 2 hours, which means someone manually has to click refresh in the browser in each department, which is not ideal. We preferably do not want to install browser extensions such as "Auto Refresh".  

 

Do you have any suggestions?

 

Thanks in advance

1 ACCEPTED SOLUTION
MAwwad
Super User
Super User

If you are using PowerBI Report Server, you can set up automatic refresh of the dashboard in the report server configuration. If you are using PowerBI Service, you can schedule the refresh in the data source settings or use PowerBI API's to programmatically refresh the report.

Additionally, you can consider using PowerBI embedded or PowerBI API's to programmatically refresh the report and display it on the wall-mounted TV using a custom application or solution.

View solution in original post

5 REPLIES 5
Musikologo97
Frequent Visitor

excuse my English: One solution used was that my report uses (publish to the web (public)), I generate the IFRAME. On the other hand, in 1 HTML with the help of Javascript I make 1 browser refresh every 30 minutes.

djurecicK2
Super User
Super User

Hi @ziggedzh ,

 If you are using a Power BI Dashboard, (not report), the dashboard tiles will update within 15 minutes of the import dataset refresh.

 

MAwwad
Super User
Super User

If you are using PowerBI Report Server, you can set up automatic refresh of the dashboard in the report server configuration. If you are using PowerBI Service, you can schedule the refresh in the data source settings or use PowerBI API's to programmatically refresh the report.

Additionally, you can consider using PowerBI embedded or PowerBI API's to programmatically refresh the report and display it on the wall-mounted TV using a custom application or solution.

Thank you MAwwad

but every single item suggested needs a specific deepening through a web search.... (a Google or Bing search).

It would be great have a direct link to each topic 🙂 based on your experience... 

Don't get me wrong but thanks anyway

As @djurecicK2 mentioned, if you're using a Power BI dashboard, not a report, then the tiles should automatically update themselves without user interaction.

 

If you're using a report, then that's a different story. In that case, since you mentioned using Import Mode, the only way to get your report's visuals to auto-update on their own is to use an external tool. Even Automatic Page Refresh does not work when you use Import Mode, and that's regardless of licensing.

 

I built a custom tool called Displagent to handle the that particular case, where you have a report on Import Mode and you need the visuals to auto-refresh.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.