How to Auto Update Power BI Data

Manually refreshing your Power BI reports every day is a tedious chore that leaves your team looking at outdated data for decision-making. If you're tired of clicking the refresh button and waiting, there's a much better way. This guide will walk you through exactly how to set up an automatic data refresh in Power BI, so your dashboards are always current and you can get back to more important work.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Automate Your Power BI Refresh?

In business, timing is everything. A decision based on last week's sales figures might be completely wrong today. Manually updating reports is not just time-consuming, it's a major bottleneck that can lead to poor decisions.

When you automate the process, you create a "single source of truth" that everyone in the company can trust. Stakeholders can confidently open a report knowing it reflects the most current information available, whether that’s hourly sales data, daily marketing campaign performance, or weekly inventory levels. Setting this up transforms your Power BI reports from static snapshots into dynamic, living dashboards that drive proactive decision-making.

Understanding the Core Components

Before diving into the steps, it helps to understand the two key pieces of the puzzle: the Power BI Service and the Data Gateway. Getting these right is the secret to a successful setup.

Power BI Service: Your Report's Online Home

Power BI Desktop is where you build your reports - connecting to data, creating models, and designing visuals. However, the automation magic happens in the Power BI Service, which is the cloud-based platform (app.powerbi.com) where you publish, share, and manage your reports. Once a report is published here, you can set it to refresh automatically without ever opening the desktop application again.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Data Gateway: The Bridge to Your Local Data

What if your data isn't in the cloud? What if it's in an Excel file on your company’s server or in a SQL database sitting in your office? This is where the On-Premises Data Gateway comes in.

The gateway is a small piece of software you install on a computer within your local network. It acts as a secure bridge, allowing the Power BI Service (in the cloud) to reach down into your on-premises data sources to fetch new data for a refresh. Without it, Power BI has no way to access files and servers that aren't publicly available on the internet.

• When you DON'T need a gateway: If your data sources are already in the cloud (e.g., Azure SQL, SharePoint Online, Salesforce), you won't need to install a gateway.
• When you DO need a gateway: If you use any on-premises data sources (e.g., a local SQL Server, a local folder of Excel/CSV files, an Oracle database), the gateway is non-negotiable.

A Step-by-Step Guide to Setting Up Scheduled Refresh

With the basics covered, let's walk through the exact steps to get your report updating automatically. We'll start from a report you've already built in Power BI Desktop.

Step 1: Publish Your Report to the Power BI Service

First, you need to get your report from your computer into the cloud. This one is simple.

1. In Power BI Desktop, with your report open, go to the Home tab.
2. Click the Publish button.
3. You'll be prompted to sign into your Power BI account if you haven't already.
4. Select a destination "Workspace" to publish the report to. For personal use, "My workspace" is fine. For team collaboration, choose the appropriate shared workspace.

Once it's finished, you'll get a success message with a link to open the report directly in the Power BI Service.

Step 2: Locate Your Dataset Settings

In Power BI, the refresh schedule isn't applied to the report itself, but to its underlying dataset. A single dataset can be used to power multiple reports, so refreshing the dataset updates all of them at once.

1. Log in to the Power BI Service (app.powerbi.com).
2. In the left-hand navigation pane, find the workspace where you published your report.
3. Inside the workspace, you'll see separate items for your new Report and Dataset. They will likely have the same name.
4. Hover over your dataset, click the three dots (...) for "More options," and select Settings.

This is your command center for managing the data connection and refresh schedule.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: A Quick Detour - Install and Configure the Data Gateway (If Needed)

If your report uses on-premises data, you'll see a "Gateway connection" section in the settings page with a warning that you need a gateway. If you only use cloud sources, you can skip this step!

1. Download the On-Premises Data Gateway (standard mode) from the official Microsoft website.
2. Run the installer on a computer that is always on and has access to your data sources (like a server). A personal laptop that shuts down or leaves the network is a bad choice.
3. Follow the installation prompts. You'll sign in with your Power BI account credentials to register the gateway.
4. Once installed, go back to the Dataset Settings page in the Power BI Service. Under the "Gateway connection" section, your new gateway should appear. If it's correctly configured, you will be able to map your on-premises data sources to the gateway.

Simply put, you are telling Power BI Service: "To get the data from my local SQL server, use this gateway."

Step 4: Update Your Data Source Credentials

Next, Power BI needs permission to access your data on your behalf during a refresh. In the Dataset Settings, expand the Data source credentials section.

• For each data source listed, you'll see a link to "Edit credentials."
• You'll be prompted to enter a username/password, an API key, or use OAuth2 to sign in, depending on the source. It’s crucial that the authentication method you choose allows for a non-interactive sign-in, as you won’t be there to approve it during an automatic refresh.
• Once you've entered them correctly, you'll see a confirmation message.

If the credentials are wrong or expire, your scheduled refresh will fail, so it's a good idea to use a service account with a non-expiring password if possible.

Step 5: Define Your Refresh Schedule

Here's the final step where you set the magic in motion. Expand the Scheduled refresh section.

1. Toggle the switch to "On."
2. Refresh frequency: Choose either "Daily" or "Weekly."
3. Time zone: Select the correct time zone for your schedule.
4. Time: Click "Add another time" to specify the exact time of day you want the refresh to run.

How many times you can refresh depends on your license and capacity:

• Power BI Pro: You can schedule up to 8 refreshes per day.
• Power BI Premium: You can schedule up to 48 refreshes per day (every 30 minutes).

Finish by clicking Apply. That’s it! Your report will now update automatically according to your schedule.

Troubleshooting Common Issues

Sometimes, a refresh fails. Don't panic. Here are the most common culprits and how to fix them.

How to Check Your Refresh History

In the workspace, hover over your dataset, click the three-dot menu, and select Refresh history. This page will show you the status of every past refresh (scheduled, on-demand), when it happened, and whether it succeeded, failed, or was disabled.

Graphed

Still Building Reports Manually?

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

Watch the Demo

"The Gateway is Offline"

Problem: Power BI can't connect to your data gateway. Solution: This usually means the machine where the gateway is installed is turned off, has lost its internet connection, or the gateway service isn't running. Ensure the machine is powered on and connected to the network. You might need to restart the "On-premises data gateway service" in the Windows Services app.

"Invalid Credentials"

Problem: The username or password for one of your data sources has expired or changed. Solution: Go back to Dataset Settings > Data source credentials and re-enter the correct, up-to-date credentials for the failed source.

"Could Not Find File"

Problem: A source file (like an Excel or CSV file) has been moved, renamed, or deleted. Solution: The path to a file data source is absolute. You'll need to open the .pbix file in Power BI Desktop, update the source location in the Power Query Editor (Transform data > Data source settings), and then re-publish the report.

Final Thoughts

Setting up a scheduled refresh in the Power BI Service transforms your static reports into living dashboards. By connecting your data sources, configuring a gateway for on-premises data, and setting a refresh schedule, you ensure your team always has the latest information for making critical decisions.

While Power BI is a robust tool, getting multiple data sources connected and managed can be cumbersome. At Graphed, we streamline this entire process for marketing and sales data. We connect to your platforms like Google Analytics, Shopify, and Salesforce in seconds, letting you build beautiful, auto-updating dashboards with simple natural language. Instead of wrestling with gateway configurations and obscure error messages, you can just ask for the report you need, and we build it and keep it fresh for you.