🚀 Save 48% on Premium Plan = Get all features for just $2.08/month (Yearly Plan). Upgrade Now

How to Auto Refresh a Power BI Report in the Browser

How to auto refresh a Power BI report in the browser

A Power BI report open in a browser usually does not update by itself. When the semantic model refreshes on its schedule, the report on screen can keep showing the old numbers until someone reloads the page or clicks Refresh visuals. That is a real problem for a report on an office TV or a wall monitor, where nobody is around to click.

Power BI's built-in fix, automatic page refresh, works only with DirectQuery and similar live sources, and in a Pro workspace it can't refresh more often than every 30 minutes. For any other report, the simplest way to auto refresh a Power BI report is to reload the browser page on a timer. Auto Refresh Page does this in Chrome, Edge and Firefox: pick an interval that matches your data refresh schedule, and the report reloads with the latest data on its own.

img
English 
Running 
Time Interval
Refresh List
Detect Keyword
5 Seconds
10 Seconds
15 Seconds
5 Minutes
10 Minutes
✓ 15 Minutes

Add custom time 

+ Custom Time

Random Interval 

+ Random Time

Why doesn't my Power BI report update automatically?

Power BI has two separate kinds of refresh, and a report only changes on screen when the second one happens.

  • Data refresh loads new data from your sources into the semantic model, usually on a schedule. A model in a shared (Pro) workspace can have up to 8 scheduled refreshes a day, and a model on Premium, Premium Per User or Fabric capacity up to 48.
  • Visual refresh is the report asking the model for its numbers again. In the Power BI service, this happens when the browser loads or reloads the report, when you click Refresh visuals in the top menu bar, or through automatic page refresh.

Microsoft's data refresh documentation gives this exact example: if you open a report and a scheduled refresh then updates the imported data, "the report visuals in the open browser won't update until a refresh of report visuals is initiated."

There is one exception. Power BI now updates open Import-mode reports after a model refresh, but only for users with write permission on the semantic model, and Microsoft notes it can become unreliable when more than about 1,000 users have that permission. A display account that can only view the report, which is the usual and safer setup for a TV, doesn't get these updates.

Automatic page refresh or a browser auto refresh?

Automatic page refresh is set by the report author in Power BI Desktop or the service, under Page refresh in the formatting pane. The table compares it with reloading the page from the browser.

Power BI automatic page refreshBrowser auto refresh
Import modeNot supportedWorks
DirectQuerySupportedWorks
Shortest interval in a shared (Pro) workspace30 minutesWhatever you set
Shortest interval on Premium or Fabric capacitySet by your capacity admin (5 minutes by default)Whatever you set
Who sets it upThe report author, for each pageWhoever runs the screen, without editing the report
What it showsFresh results from the DirectQuery sourceThe latest data in the semantic model when the page reloads

If your report uses DirectQuery and the interval you need is allowed in your workspace, use automatic page refresh. It is built in and refreshes only the visuals. In every other case, including the most common one, an Import-mode report shown on a TV, reload the page.

How to auto refresh a Power BI report in the browser

  1. Install Auto Refresh Page from the Chrome Web Store. It is free and also available for Microsoft Edge and Firefox.
  2. Sign in to the Power BI service, open the report and go to the page you want on screen. The page is part of the web address, so every reload comes back to the same page.
  3. Click the Auto Refresh icon. On the Time Interval tab, choose a preset such as 15 Minutes, or click + Custom Time to enter your own interval (see the table below).
  4. Leave Hard Refresh unticked. A normal reload makes the report ask the model for its numbers again. Hard Refresh only downloads the page's own files again, which makes each reload slower.
  5. For a screen that runs all the time, open Advanced Options and tick Start auto refresh on browser start, so refreshing starts again after the computer restarts. See browser startup options.
  6. Click Save and check that the switch at the top of the popup reads Running.
  7. Make the report fill the screen. Use View → Full screen in the report, or press F11 for browser full screen.

If you want to see when the next reload will happen while you set things up, tick Show visual timer on the webpage, then turn it off again before the screen goes live.

What refresh interval should I use?

A reload can only show data that the semantic model already has. Reloading every 30 seconds does not help when the model refreshes eight times a day. It just sends more queries to Power BI. Match the interval to how often your data changes:

How the report gets its dataSuggested reload interval
Import mode, shared (Pro) workspace, up to 8 refreshes a day30 to 60 minutes
Import mode on Premium, PPU or Fabric, up to 48 refreshes a day15 minutes
DirectQuery, when you need updates more often than every 30 minutes in a Pro workspace5 to 15 minutes
You are not sure15 minutes, then adjust

With DirectQuery, each reload sends queries to your data source. Check with whoever looks after that database before you use short intervals on several screens. Microsoft's own advice for automatic page refresh applies here too: don't refresh more often than new data actually arrives.

How to set up a Power BI report on a TV or wall display

  • Use a view-only account. The screen is on show to everyone, so give its account permission to view the report and nothing more. The account still needs the license your organization requires for viewing that report.
  • Stop the computer from sleeping. In the operating system's power settings, set the screen and the computer never to sleep while plugged in. A computer that is asleep doesn't reload anything.
  • Keep the tab awake. Chrome's Memory Saver and Edge's sleeping tabs can put background tabs to sleep. Auto Refresh Page stops that from happening to any tab with an active refresh timer, so the report keeps reloading even if it is not the tab in front.
  • Several reports on one computer? Open each report in its own tab or window and save a timer for each. All of them appear in the Refresh List, where one switch pauses or resumes them together. See how to manage multiple URLs.
  • Plan for sign-in. A reload counts as activity, which helps with sites that sign you out when you are idle (see how to keep a session alive). It can't extend a sign-in that your organization limits to a fixed number of hours. When that happens, the screen shows the sign-in page until someone signs in again.

Does this work with Power BI dashboards and apps?

Yes. Auto Refresh Page reloads whatever page is open, so it works the same way for reports opened from a Power BI app and for dashboards. On a dashboard, tiles pinned from Import-mode models are updated during each data refresh. Microsoft notes that pinned live report pages are not, and suggests using the browser's refresh button for them, which is exactly what a timed reload does.

You don't need to change your report, your workspace or your license to keep a Power BI screen up to date. Install Auto Refresh Page, open the report, set an interval that matches your data refresh, and leave it running. The same steps work for any other dashboard that only updates when you reload the page. For more on intervals, see custom time intervals.

Frequently Asked Questions:

  1. 1. Why doesn't my Power BI report refresh automatically in the browser?

    A data refresh updates the semantic model, but an open report only redraws its visuals when the page loads, when someone clicks Refresh visuals, or through automatic page refresh. Power BI updates open Import-mode reports after a model refresh only for users with write permission on the model.

  2. 2. Does Power BI automatic page refresh work with Import mode?

    No. Automatic page refresh works with DirectQuery and some live connections. If a report uses Import mode, the Page refresh option doesn't appear. To refresh an Import-mode report on screen, reload the browser page on a timer.

  3. 3. What is the minimum automatic page refresh interval in Power BI Pro?

    In a shared (Pro) workspace, the minimum is 30 minutes. On Premium, Premium Per User or Fabric capacity, the capacity admin sets the minimum, which is five minutes by default.

  4. 4. How many times a day can a Power BI semantic model refresh?

    Up to 8 scheduled refreshes a day in a shared (Pro) workspace, and up to 48 on Premium, Premium Per User or Fabric capacity. Refreshes you start by hand with Refresh now don't count toward the limit of eight.

  5. 5. Does reloading the browser refresh the Power BI data?

    No. A reload makes the report fetch the latest data from the semantic model, but it doesn't load new data from your sources. That still happens through scheduled or on-demand data refresh, or directly from the source for DirectQuery reports.

  6. 6. How do I keep a Power BI report up to date on a TV?

    Open the report in Chrome, Edge or Firefox with a view-only account and set Auto Refresh Page to reload it every 15 to 60 minutes, depending on your data refresh schedule. Then show it in full screen and stop the computer from going to sleep.

  7. 7. Will auto refresh sign me out of Power BI?

    No. A reload uses your existing sign-in. It can't extend a sign-in that your organization limits to a set number of hours, so the screen may show the sign-in page when that time runs out.