How to Refresh Power BI Dataset Automatically

Is hitting the “Refresh” button in Power BI a core part of your workday routine? You’re not alone. While Power BI is a fantastic tool for visualizing data, manually updating datasets burns valuable time and increases the risk of making decisions based on old information. This guide will walk you through setting up an automatic, scheduled refresh for your datasets, ensuring your dashboards are always current and reliable, no manual work required.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother with a Scheduled Refresh?

Setting up an automatic refresh might seem like a small technical task, but it fundamentally changes how you and your team interact with data. When your reports update themselves on a consistent schedule, you gain several key advantages:

• Timely Decisions: You're always looking at the most current data available, allowing you to react quickly to new trends, opportunities, or problems.
• Increased Efficiency: It liberates you from the tedious, repetitive task of manually refreshing reports. That time is better spent analyzing insights and driving strategy.
• Greater Reliability: Automatic processes eliminate human error. You’ll never have to wonder if you forgot to refresh a report before a big meeting.
• Consistent Access: Your whole team sees the same, up-to-date information, creating a single source of truth and a more data-driven culture.

In short, it’s a foundational step in moving from reactive data-pulling to proactive, data-informed decision-making.

Prerequisites: What You Need Before You Start

Before you jump into the settings, make sure you have a few things in place. Tackling these first will save you from hitting frustrating roadblocks later.

1. A Power BI Pro or Premium Per User (PPU) license. The ability to schedule a data refresh is a feature of the paid Power BI tiers. Manual refreshes work on the free version, but automation requires a Pro or PPU license. A Premium capacity subscription also enables this.
2. A published report and dataset. The configuration for scheduled refresh happens in the Power BI Service (the web-based application), not in Power BI Desktop. This means you must have already published your report from the Desktop app to a Workspace online.
3. Understanding of your data sources. This is the most important part. Are you connecting to cloud-based sources (like SharePoint Online, Azure SQL, Google Analytics) or on-premises sources (like a local SQL Server, an Excel file on your C: drive, or a file on a shared network drive)? The setup process is different for each.

With these prerequisites handled, you're ready to set up your automatic refresh.

Setting Up a Refresh for Cloud Data Sources

If all your data comes from cloud-based platforms, the process is wonderfully straightforward. Power BI can connect to these sources directly over the internet without any extra software. Here's how to get it done.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Navigate to Your Workspace in Power BI Service

Log in to app.powerbi.com. On the left-hand navigation pane, find and click on the Workspace where you published your report.

Step 2: Find Your Dataset and Open Settings

Inside your Workspace, you'll see a list of all your assets: dashboards, reports, and datasets. The scheduled refresh is configured at the dataset level. Find the dataset that your report is built on. Hover over it, click the three-dot menu (...), and select Settings.

Step 3: Configure Data Source Credentials

In the Settings screen, expand the Data source credentials section. Power BI needs to know how to log into your data source on its own. For cloud sources, this is usually very simple.

• Click on Edit credentials.
• You will likely be prompted to sign in with your account for that service (e.g., your SharePoint or Google account).
• The authentication method should typically be set to OAuth2, which securely allows Power BI to access data on your behalf. Just follow the login prompts.

Once you’ve successfully signed in, you’ll see a confirmation message, and you can move on to the actual scheduling.

Step 4: Set Up the Refresh Schedule

Now, expand the Scheduled refresh section.

• Toggle the switch to On.
• Refresh frequency: Choose whether you want the refresh to happen Daily or Weekly.
• Time zone: Select your local time zone to ensure refreshes happen at the correct time of day.
• Time: Click Add another time to set the specific times for the refresh.

Step 5: Set up Refresh Failure Notifications

Under the time scheduler, check the box for Send refresh failure notifications to the dataset owner. This is a crucial step! If your credentials expire or a data source changes, the refresh will fail. This email notification is your first line of defense, letting you know that something is wrong so you can fix it before anyone notices outdated data.

Click Apply, and you're all set! Your Power BI dataset will now refresh automatically without you ever having to lift a finger.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Refreshing On-Premises Data Sources via a Gateway

What if your data lives on a local file server, a network drive, or a SQL server inside your company’s network? The Power BI Service, being a cloud application, can't directly reach into your private network. This is where the On-premises data gateway comes in.

What is a Data Gateway?

Think of the gateway as a secure private bridge. You install this small piece of software on a computer within your local network. It creates a secure, encrypted connection between your local data and the Power BI Service in the cloud. When a refresh is triggered, Power BI sends a query to the gateway, the gateway securely fetches the data from your local source, and then sends it back up to Power BI to update the dataset.

Step 1: Install and Configure the Gateway

First, you need to install the gateway on a computer that is always on and connected to the internet - typically a server.

1. In Power BI Service, click the download icon (arrow pointing down) in the top-right corner and select Data Gateway.
2. Download the Standard mode gateway. (Personal mode exists but is more limited and we don't recommend it for team use).
3. Run the installer on your server. After installation, you’ll be prompted to sign in with your Power BI account. This registers the gateway with your Power BI tenant.
4. Give your gateway a unique name and create a recovery key. Save this key somewhere safe! You will need it if you ever have to move or restore your gateway.

Step 2: Connect Your Data Source to the Gateway

Once the gateway is running on your server, head back to your dataset settings in the Power BI Service. This time, you'll see a Gateway and cloud connections section.

• Power BI will often detect that your dataset requires a gateway.
• Under Gateway and cloud connections, you should see your gateway name listed. You'll need to map your on-premises data files to it.
• For a local Excel file, you'll need to enter the username and password for the Windows account that has rights to access that file. For a SQL database, you’ll enter the database credentials.
• After entering the credentials, click Apply. If the connection is successful, you'll see a green checkmark indicating that Power BI can now reach your data via the gateway.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Set the Refresh Schedule

From here, the process is exactly the same as for cloud sources. Expand the Scheduled refresh section, toggle it on, set your desired times, enable failure notifications, and click Apply. Power BI will now use the gateway as its bridge to automatically update your on-premises data sources.

Common Problems and Troubleshooting

Scheduled refreshes are fantastic when they work, but they can occasionally fail. Here are the most common culprits:

• Credential Errors: The most frequent issue. Your password for a data source changed, or an access token expired. The fix is to go back into Dataset Settings > Data source credentials and re-enter your login information.
• Gateway is Offline: For on-premises refreshes, the computer hosting the gateway might have been turned off, lost internet connection, or the gateway service stopped running. Ensure the server is online and the gateway status is green.
• Data Source Schema Changes: If someone renames a column, deletes a worksheet, or changes a file path from C:\Reports\Sales.xlsx to C:\Old Reports\Sales.xlsx, the refresh will break because Power BI can no longer find the data it expects.
• Refresh Timeout: For very large datasets, the refresh can sometimes take longer than the allowed time limit (typically 2 hours on a Pro license). To fix this, you may need to optimize your data model in Power BI Desktop or use Premium capacity for longer time limits.

Final Thoughts

Setting up an automated data refresh in Power BI is a game-changer for productivity and reliability. By taking a few minutes to configure your cloud credentials or set up a data gateway for on-premises sources, you can ensure your reports are always fueled by fresh data, freeing you to focus on analysis rather than admin work.

While Power BI’s refresh scheduling is a powerful feature, connecting all your data sources and managing complex setups like gateways can still feel like a chore. At Graphed, we built our tool to eliminate that complexity entirely. Our platform offers one-click connections to your marketing and sales data sources - from Google Analytics and Shopify to Salesforce and Facebook Ads - and keeps your dashboards updated in real-time, automatically. Instead of clicking through settings, you can simply ask for the dashboard you need in plain English and get back to growing your business. If you're ready to move beyond manual refreshes and complex setups, give Graphed a try.