How to Make Power BI Refresh Data Automatically

Nothing deflates the value of a dashboard faster than realizing you’re looking at last week’s numbers. Keeping your Power BI reports fresh is a must for making timely decisions, but constantly hitting the 'refresh' button manually is a chore nobody wants. This guide walks you through setting up automatic data refreshes in Power BI, so your dashboards are always current without you lifting a finger.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Automatic Refreshes Are a Game Changer

Before jumping into the "how," let’s quickly touch on the "why." If you’re manually refreshing your dashboards, you’re likely familiar with the headaches it causes:

• It’s a time sink. Your Monday morning shouldn’t start with a routine of opening Power BI Desktop, refreshing each dataset, and republishing reports. This manual work adds up quickly and pulls you away from actual analysis.
• It introduces risks. What if you forget? Or what if you’re on vacation? Decisions might be made based on outdated information, leading to misguided strategies and missed opportunities.
• It creates an information bottleneck. Your team comes to rely on you to provide them with the latest data. If you’re busy, they’re left waiting, slowing down the entire decision-making process for everyone.

Automating this process fixes all of that. It ensures data consistency, frees up your time for more impactful work, and empowers your team with self-serve access to the most current information. Everyone is quite literally on the same page, all the time.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding How Power BI Refreshes Data

In Power BI, the way you connect to your data source determines how it can be refreshed. There are three main methods, but for setting up automatic refreshes, you’ll most often be dealing with one: Import Mode.

• Import Mode: This is the most common method. Power BI takes a copy of your data from your source (like an Excel file, a SQL database, or Google Analytics) and pulls it into your Power BI report file (.pbix). Because it’s a snapshot, you must schedule a refresh to get the latest data. This article focuses primarily on this mode.
• DirectQuery: In this mode, no data is copied. Power BI queries the original data source directly every time a user interacts with a visual. The data is always live, so you don’t need to schedule a refresh. This is generally used for very large datasets where importing isn’t practical.
• Live Connection: This is similar to DirectQuery but is specifically for connecting to SQL Server Analysis Services (SSAS), Azure Analysis Services (AAS), or Power BI datasets. The data remains in the source model, and you get real-time results.

For most users, Import Mode offers the best performance and functionality. The rest of this guide will show you how to set up a scheduled refresh for reports using this method.

Setting Up Your First Scheduled Refresh

The process of automating a data refresh happens in the Power BI Service (the cloud-based version), not in Power BI Desktop. The core steps involve publishing your report, sometimes installing a 'gateway' to create a bridge to your data, and then setting your schedule.

Step 1: Publish Your Report to Power BI Service

Your journey starts in Power BI Desktop. After you’ve built your report and are happy with its design, you need to publish it to the cloud.

1. From the Home tab in Power BI Desktop, click the Publish button.
2. If prompted, sign in to your Power BI account.
3. Select the Workspace you want to publish the report to. Avoid using "My Workspace" for team reports, it’s better to use a dedicated workspace for collaboration.
4. Once publishing is complete, you’ll see a success message. Click the link to open your report directly in the Power BI Service.

When you publish a .pbix file, Power BI uploads two components to your workspace: the report itself (the visuals and pages) and the underlying dataset (the data model, tables, and connection information).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Install and Configure a Data Gateway

This is the most crucial — and often most confusing — step. Think of a data gateway as a secure bridge that allows Power BI in the cloud to access data sources that are located on-premises (i.e., on your computer or a company server). You need a gateway if your report connects to sources like:

• An Excel file on your local C: drive
• A local SQL Server database in your office
• Any other data source that isn’t publicly accessible on the internet

You do NOT need a gateway for completely cloud-based data sources such as Azure SQL Database, SharePoint Online, or Google Analytics. If you’re only using cloud sources, you can skip to the last section for a simpler process.

For on-premises data, here’s how to set up the gateway:

1. Download the Gateway: In the Power BI Service, click the download icon (arrow pointing down) in the top-right corner and select Data Gateway. You want the standard mode, which is recommended for most business use cases.
2. Install It: Run the installer on a computer that is always on and connected to the internet. This computer acts as the bridge, so if it’s turned off, the refreshes will fail. Gateways are typically installed on a server, but a reliable desktop can suffice for smaller setups.
3. Sign In and Register: Follow prompts to sign in with your Power BI account. Then select "Register a new gateway on this computer," give it a descriptive name, and create a recovery key. Save this key securely, as you’ll need it if you migrate or restore the gateway.

Once the gateway is running, it’s ready to be configured in the Power BI Service.

Step 3: Connect Your Dataset and Data Sources to the Gateway

With the gateway active, you now have to tell Power BI to use it for your dataset:

1. In Power BI Service, go to the workspace where you published your report.
2. Find your dataset (matching your report’s name, with an orange icon). Hover, click the three-dot menu (...) and select Settings.
3. Expand the Gateway and cloud connections section. You should see "On-premises data gateway."
4. Power BI will attempt to automatically detect the data sources used in your report. Confirm or manually add sources to the gateway as needed.
5. Map Your Data Sources: For each data source requiring the gateway, select it from the dropdown menus to link it to the gateway.
6. Enter Credentials: Under Data source credentials, click "Edit credentials" for each on-premises source. Enter the necessary authentication details (SQL login, Windows credentials, etc.). Power BI stores these securely.

When you see a green "Connection successful" message, your bridge is working!

Step 4: Set the Refresh Schedule

This final step tells Power BI when and how often to refresh your data:

1. In the dataset’s Settings page, scroll to Scheduled refresh and expand it.
2. Toggle Keep your data up to date to On.
3. Choose your Refresh frequency (Daily or Weekly).
4. Select your Time zone to match your preferred schedule.
5. Click Add another time to specify multiple refresh times if desired.
6. Note: The number of scheduled refreshes depends on your Power BI capacity. Pro accounts allow up to 8 per day, Premium offers up to 48.
7. Enter email addresses in Send refresh failure notifications to to get alerts if something goes wrong.
8. Click Apply to save your schedule.

Your report now updates automatically according to the schedule!

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Handle Cloud-Only Data Sources (The Easy Way)

If your Power BI report only connects to cloud data sources (like SharePoint, Salesforce, Google Sheets, Azure), the process is simpler, no gateway is needed.

1. Publish Your Report: Same as step 1 above.
2. Go to Dataset Settings: Find your dataset in Power BI Service, then go to its Settings.
3. Edit Credentials: Skip the gateway section, go to Data source credentials. Click "Edit credentials" and use OAuth2 authentication where available. Sign in and grant access as prompted.
4. Schedule Your Refresh: Scroll to Scheduled refresh, turn it on, and set your preferred times just like before.

Since Power BI Service can access cloud sources directly, no on-premises "bridge" is required. It’s quick to set up and keeps your cloud data fresh.

Troubleshooting Common Refresh Errors

Sometimes refreshes fail. It happens to everyone. Here are common causes and how to fix them:

• Credential Errors: The message says, "Failed to update data source credentials." Usually, the password has expired or changed. Re-enter credentials in Dataset Settings.
• Gateway Is Offline: If the gateway machine is asleep, off, or disconnected, refreshes fail. Ensure the gateway computer is reliable and always on.
• Data Source Not Reachable: The server might be down or firewall settings block access. Check with IT if needed.
• Data Source Structure Changed: Renamed or deleted columns can cause errors. Update your queries in Power BI Desktop, then republish.

You can check Refresh history in dataset settings for details on each attempt and failure reasons.

Final Thoughts

Automating data refreshes in Power BI transforms static reports into a dynamic, data-driven environment. While initial setup—especially with an on-premises gateway—may seem complex, the time saved is well worth it.

At Graphed, we believe insights should be accessible easily. Our AI data analyst was built for this purpose. Connect sources like Google Analytics, Shopify, or Salesforce to Graphed, and your dashboards update automatically in real-time. Plus, ask for new reports or insights in plain English, freeing you from manual BI tasks.