Does Power BI Update Automatically?

Power BI dashboards can absolutely update automatically, but they don't do it straight out of the box. You need to configure the right settings in the right place to make it happen. This article will walk you through exactly how Power BI refreshes work and the steps to set up your own automatic updates, so your reports always have the latest data.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Understanding the Two Sides of Power BI

First, it's essential to understand that Power BI has two primary environments: Power BI Desktop and the Power BI Service. How data refreshes work is completely different in each one.

• Power BI Desktop: This is the free application you install on your computer to build your reports. You connect to data sources, transform data in the Power Query Editor, and create your charts and tables here. When you're working in the Desktop app, data updates are manual. Hitting the "Refresh" button in the Home ribbon pulls in the most current data from your sources at that moment.
• Power BI Service (app.powerbi.com): This is the cloud-based service where you publish, share, and collaborate on your reports. This is where the magic of automation happens. You can't set up automatic refreshes in the Desktop application, it must be done in the Service.

The typical workflow is: build locally on your Desktop, then publish to the Service to set up automatic refreshes and share with your team.

Setting Up a Scheduled Refresh: Your Step-by-Step Guide

The most common way to automate updates in Power BI is by using a "Scheduled Refresh." This tells the Power BI Service to automatically pull in fresh data from your sources at specific times you choose. Here's how to set it up.

Step 1: Publish Your Report

Once your report is built in Power BI Desktop, you need to publish it to the Power BI Service. Simply click the "Publish" button on the Home tab, choose a workspace, and wait for it to upload.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Install and Configure a Data Gateway

This step is only necessary if your data sources are "on-premises" — meaning they are located on a local computer or server within your company's network. This includes sources like:

• Excel files on your hard drive
• SQL Server databases inside your company's firewall
• Files on a local network share

If you're only using cloud-based data sources (like Google Analytics, Salesforce, or an Azure SQL database), you can often skip this and just enter your credentials directly in the Power BI Service.

A data gateway is a secure bridge that allows the Power BI Service (in the cloud) to connect to your local data sources. Without it, Power BI has no way to access a file sitting on your C: drive.

To set it up:

1. Download the On-premises data gateway (standard mode) from the official Microsoft Power BI website.
2. Install it on a computer that is always on and connected to the internet. A server is ideal, but a dedicated desktop can also work.
3. Sign in with your Power BI account and follow the prompts to register the gateway.

Once installed, the gateway creates that secure connection needed for the scheduled refresh to work.

Step 3: Configure Your Dataset Settings in the Power BI Service

Now, head over to the Power BI Service (app.powerbi.com) in your web browser.

1. Navigate to the workspace where you published your report.
2. Find your dataset in the list (it will have the same name as your report and an orange icon). Hover over it, click the three-dot menu (...) and select Settings.
3. Gateway Connection: If you installed a gateway, expand this section. You should see your gateway listed. Make sure it has a green status check, meaning it's online and ready. You may need to map your data sources to the gateway and enter their credentials (e.g., the username and password for your SQL server).
4. Data Source Credentials: If you're using cloud-only sources, this is where you'll sign in. Expand this section, click "Edit credentials" for each source, and sign in.
5. Scheduled Refresh: This is the main event. Expand this section and toggle the switch to "On."

You can now configure the schedule:

• Refresh frequency: Choose "Daily" or "Weekly."
• Time zone: Select your local time zone so the refreshes happen when you expect them to.
• Time: Click "Add another time" to set specific times for the refresh. You can add multiple slots throughout the day. The number of slots you can add depends on your Power BI license.
• Send refresh failure notifications to: It's a good idea to check this box. This way, you'll get an email if a refresh fails for any reason (like if a password expired or the source file was moved).

Once you're done, click Apply. That's it! The Power BI Service will now automatically refresh your dataset according to the schedule you set.

Going Beyond Scheduled Refreshes: DirectQuery and Live Connection

Scheduled refreshes are perfect for many situations, but they aren't true real-time. The data is only as fresh as your last scheduled update. For situations that require up-to-the-second data, Power BI offers two other connection methods.

When you first connect to a data source in Power BI Desktop, you're usually given a choice between Import, DirectQuery, or Live Connection.

• Import Mode (The Default): This is the mode used for Scheduled Refreshes. Power BI takes a full copy of your data from the source and stores (caches) it inside your PBIX file. This makes reports very fast but means the data becomes stale until the next refresh.
• DirectQuery: In this mode, no data is copied into your Power BI file. Instead, every time you interact with a report — like clicking a slicer or filtering a chart — Power BI sends a query directly to the source database to fetch the latest data. This means your report is always showing what's in the database right now. However, it can be slower depending on the performance of your underlying data source.
• Live Connection: This is similar to DirectQuery but is used specifically for connecting to certain Microsoft data models like SQL Server Analysis Services (SSAS), Azure Analysis Services, and other Power BI datasets. Like DirectQuery, it leaves the data at the source, giving you a live view of the model.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

When should you use each?

• Use Import Mode for most scenarios. It's fast, flexible, and the scheduled refresh is sufficient for daily or hourly reporting needs.
• Use DirectQuery when you have a very large dataset that won't fit into memory or when your business stakeholders absolutely need to see real-time data (e.g., in a manufacturing or operations dashboard).
• Use Live Connection when your organization already has a well-established data model in a compatible source like SSAS that you want to connect to and visualize.

How Your Power BI License Affects Automatic Refreshes

The ability to automatically refresh data is a key feature that varies with different Power BI licenses.

• Power BI Free: This license is unsupported in the Power BI Service workspace where you can schedule refreshes. It's intended for personal analysis in the Desktop app.
• Power BI Pro: This is the standard license for business users. It allows you to publish reports to shared workspaces and schedule up to 8 refreshes per day per dataset.
• Power BI Premium (Per User or Capacity): The Premium licenses are for larger-scale enterprise needs. They allow you to schedule up to 48 refreshes per day, providing much more frequent updates for more critical reports.

Common Refresh Errors and How to Troubleshoot Them

Sometimes, your scheduled refresh will fail. When it does, you'll get an email notification (if you enabled them). Here are a few of the most common reasons and how to fix them.

1. Gateway is Offline

The problem: Power BI can't reach your on-premise data source because the gateway bridging the connection is turned off or not connected to the internet.

The fix: Make sure the computer where the gateway is installed is powered on, online, and the gateway service is running.

2. Data Source Credentials Error

The problem: The username or password for one of your data sources has expired, changed, or is incorrect.

The fix: Go to your dataset's settings in the Power BI Service (Dataset > Settings > Data source credentials). Click "Edit credentials" and enter the updated login information.

3. Schema Changes in the Source Data

The problem: Someone renamed or deleted a column in the original data source (e.g., in the source Excel file or database table) that your report depends on.

The fix: You'll need to open the PBIX file in Power BI Desktop. Go to the Power Query Editor ("Transform data"), find the failing query step, and correct it to reflect the change in the source. Once fixed, republish the report to the service.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

4. Refresh Timeout

The problem: The data import is taking too long to complete. A Power BI Pro license has a two-hour time limit per refresh. This can happen if your dataset has grown too large.

The fix: The best long-term solution is to optimize your data model. This could mean reducing unnecessary columns, filtering out old data in the Power Query Editor, or offloading transformations back to the source database. If optimization isn't an option, you may need to upgrade to a Power BI Premium license, which allows for longer refresh times.

Final Thoughts

So, yes, Power BI does a fantastic job of updating automatically once you set it up. The primary method is the Scheduled Refresh feature in the Power BI Service, but for true real-time needs, you also have the options of DirectQuery and Live Connection. Understanding where and how to configure these features is the key to creating reliable, hands-off reports that keep your team informed.

Setting up gateways and managing data credentials can feel like a lot of work just to get an automated dashboard. At Graphed, we felt this pain and wanted to remove all that friction. We allow you to connect all your marketing platforms with a few simple clicks - no need to download gateways, manage licenses, or debug failed refreshes. Our platform handles the automated, real-time data connections for you, so you can just ask questions in plain English and get live dashboards instantly, letting you focus on insights, not setup.