How to Set Power BI to Automatically Refresh

Stale data leads to bad decisions, and manually refreshing your reports every morning is a time-consuming chore that’s easy to forget. The solution is putting your data on autopilot. This article will show you exactly how to set up automatic refreshes in Power BI so your dashboards are always current and you can focus on what the numbers are telling you.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Automatic Refresh is a Game-Changer

Diving into Power BI settings might seem like a hassle, but an automatic refresh schedule is worth its weight in gold. When your data is always up-to-date, you and your team can trust the dashboards you rely on. It’s an essential step toward building a data-driven culture.

Here’s why it matters:

• Timely Decisions: You can react to changes in your marketing campaigns, sales figures, or website traffic as they happen, not a day later. When everyone works from the same current information, decisions are faster and more accurate.
• Saves You Time: Your pre-meeting routine no longer needs to include opening Power BI Desktop, hitting "Refresh," and waiting for it to load before publishing. Automating this frees you from a repetitive and easily forgotten task.
• Keeps Everyone in the Loop: Stakeholders can access reports at any time and know they’re looking at the latest data. It eliminates the need to email static reports or PDFs that are instantly out of date.
• Improves Data Governance: A consistent refresh schedule ensures uniformity across reports. There’s no more confusion about who has the "latest version" because the live report is always the single source of truth.

Core Concepts: Power BI Desktop vs. Power BI Service

Before we jump into the steps, it’s important to understand the two main parts of the Power BI ecosystem and where automatic refresh fits in.

• Power BI Desktop: This is the free application on your computer where you build your reports. You connect to data sources, clean up data in Power Query, and design your visuals here. You cannot schedule an automatic refresh from Power BI Desktop. It only refreshes when you manually click the button.
• Power BI Service (app.powerbi.com): This is the cloud-based platform where you publish, share, and collaborate on your reports. This is where all automatic refreshes are scheduled and managed. Once your report is published to the Service, you can tell it to refresh on a recurring schedule without ever opening the Desktop file again.

The goal is to get your report from the Desktop application into the Service and then tell the Service how to access your original data sources so it can update everything on its own.

How to Set Up a Scheduled Refresh in Power BI Service

Ready to make it happen? Once you’ve published your report from Power BI Desktop to a workspace in the Power BI Service, follow these steps. For this walkthrough, we’ll assume you’re starting on the Power BI Service homepage (https://app.powerbi.com).

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Navigate to Your Dataset's Settings

In the navigation pane on the left, find and open the workspace containing your report. Inside the workspace, you’ll see tabs for "All," "Content," and "Datasets + dataflows." Click on Datasets + dataflows to filter the view.

Find the dataset for your report - it will have the same name as your Power BI file. Next to the dataset name, click the three-dot icon for "More options" (...) and select Settings from the menu.

2. Configure Data Source Credentials

This is the most critical step. For Power BI Service to refresh your data, it needs permission to access the original sources. It can’t do this without the proper credentials.

In the Settings panel, expand the Data source credentials section. You’ll see a list of every data source used in your report. You must provide valid login information for each one.

• Click on Edit credentials for a data source.
• A dialog box will appear. The options here change depending on the source type. For a cloud-based source like SharePoint or Google Analytics, choose OAuth2 as the Authentication method and sign in with your account. For a database, you might use "Basic" and enter a username and password.
• Once you sign in and grant access, you’ll see a green checkmark indicating the connection is successful. Repeat this for all data sources listed.

Note: If you are connecting to a local file (like an Excel workbook or CSV on your computer) or an on-premises database (like a local SQL server), this section will prompt you to use a gateway. We’ll cover that in more detail below.

3. Set Your Refresh Schedule

With permissions granted, you can now set the schedule. Scroll down and expand the Scheduled refresh section.

• Keep your data up to date: Toggle this switch to "On."
• Refresh frequency: Choose between "Daily" and "Weekly."
• Time zone: Select your local time zone so the refreshes happen when you expect.
• Time: Click "Add another time" to schedule your refreshes. You can set multiple times throughout the day. With a Pro license, you can schedule up to 8 refreshes per day. With a Premium license, this jumps to 48.
• Get refresh failure notifications: It’s highly recommended to check the box for "Send refresh failure notifications to the dataset owner." This way, you’ll get an email if something breaks (like an expired password), so you can fix it quickly.

After a moment, you should see a message confirming the update. That’s it! Your report is now on autopilot.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Handling On-Premises Data with a Power BI Gateway

"Gateway" might sound technical, but the concept is simple. If your data source is an Excel file on your C: drive or a SQL database inside your company’s network, there's no way for the Power BI cloud service to reach it over the internet. A gateway solves this problem.

The Power BI Gateway is a free piece of software you install on a computer within your network. It acts as a secure bridge, letting the Power BI Service send a request for fresh data through the gateway to your local source.

When do you need a gateway?

• For Excel, CSV, or text files stored on your local computer or a network drive.
• For on-premises databases like SQL Server, Oracle, or MySQL running on a server in your office.
• For any data source that isn't publicly accessible via the web.

Steps for Setting Up a Gateway

1. Install the Gateway: Download the "On-premises data gateway (standard mode)" from Microsoft’s website. You must install it on a computer that is always on and connected to your network. A server is ideal, but a dedicated desktop machine works too.
2. Configure the Gateway: Sign in with your Power BI account and follow the on-screen steps to register your gateway. This connects it to your Power BI tenant in the cloud.
3. Add a Data Source: In the Power BI Service, navigate to Settings > Manage connections and gateways. Here, you'll add connection details for your on-premises source (e.g., the server name for SQL or the file path for Excel) and provide the necessary credentials. Name your connection something descriptive.
4. Link Your Dataset to the Gateway: Go back to your dataset’s Settings page. Under the Gateway and cloud connections section, you should now be able to select your newly configured gateway connection from the dropdown menu. Once mapped, the red error icons will disappear, and you can proceed with scheduling the refresh as described above.

Troubleshooting Common Refresh Failures

Sometimes refreshes fail. The email notification you set up will be your first alert. Here are the most common culprits and how to resolve them:

Problem: Expired Credentials

The symptom: You recently changed your password for the database or Microsoft 365 account connected to Power BI.

The fix: Go to the dataset's Settings screen, navigate to "Data source credentials," click "Edit credentials," and sign in again with your new password. This is the most frequent cause of refresh failures.

Problem: The Gateway is Offline

The symptom: Your report uses an on-premises source, and you get an error that the gateway is unreachable.

The fix: Check the machine where the gateway software is installed. Make sure it's turned on, has an internet connection, and the gateway service is running. You can check the gateway’s status in Power BI Service under Manage connections and gateways.

Problem: Changes in the Data Source

The symptom: The refresh fails with an error like, "The column '[ColumnName]' of the table wasn't found."

The fix: This happens when a column name or table name has been changed in the original source file or database. You must open the PBIX file in Power BI Desktop, correct the broken steps in Power Query, and then re-publish the report to the Service.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Problem: The Refresh Times Out

The symptom: Your data model is very large, and the refresh takes longer than the allowed time limit (typically 2 hours for Pro users).

The fix: Try to optimize your model in Power BI Desktop by removing unnecessary columns, filtering rows you don't need, or making your Power Query steps more efficient. For very large datasets, you may need to explore Power BI Premium features like Incremental Refresh.

Final Thoughts

Learning how to schedule an automatic refresh is a defining step from being a casual report builder to a proficient Power BI user. By publishing your work to the Power BI Service, providing credentials, and setting a schedule, you deliver consistent, reliable, and up-to-date insights while freeing yourself from manual grunt work. For on-premises data, a gateway is the crucial link that makes it all possible.

Setting up scheduled refreshes in Power BI is a powerful step, but it often requires getting familiar with gateways, user roles, and troubleshooting email alerts. At Graphed, we designed a system to bypass this complexity entirely. We connect seamlessly to your marketing and sales tools like Google Analytics, Shopify, Facebook Ads, and Salesforce to create dashboards that refresh themselves in real-time. There's no schedule to manage or gateway to configure - your data is always live, allowing you to focus purely on the insights that drive your business forward.