How to Automatically Update Power BI Report

Manually refreshing your Power BI reports every day is a tedious and unnecessary chore. It interrupts your workflow, relies on you remembering to do it, and leaves your team making decisions based on old data. This guide will walk you through setting up scheduled refreshes in Power BI so your reports update themselves automatically, giving you back your time and making your dashboards infinitely more powerful.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Manual Refreshes Should Be a Thing of the Past

In many organizations, the reporting "process" looks something like this: download fresh data exports on a Monday morning, open Power BI Desktop, hit the refresh button, wait for it to load, and then republish the report to the cloud. You spend close to an hour on a task that is outdated by Tuesday. This manual cycle is slow, prone to errors, and simply doesn't scale.

Old data leads to bad decisions. When your leadership team is looking at a sales dashboard on Wednesday that only has data through Sunday night, they’re flying blind. The goal of a dashboard is to provide a real-time pulse of the business, which just isn't possible when it depends on someone physically clicking a button.

Automating your data refreshes solves this. It transforms a static report into a living dashboard that consistently pulls in the latest information, ensuring everyone on your team is working from the same up-to-date source of truth.

Understanding Power BI Desktop vs. Power BI Service

A key concept to grasp before we begin is the difference between the two main parts of the Power BI ecosystem:

• Power BI Desktop: This is the free application you install on your computer. It's where you build your reports. You connect to data sources, clean up your data, create your data model, and design your visuals here.
• Power BI Service: This is the cloud-based platform (app.powerbi.com) where you share and collaborate on reports. This is also where you configure the automated refreshes we'll be setting up.

Automation happens in the cloud (Power BI Service), not on your desktop computer.

Prerequisites for Automatically Updating Reports

Before you can set up a scheduled refresh, you need two things in place:

1. A Power BI Pro or Premium Per User (PPU) License. Automatic refresh is a cloud feature and requires a paid Power BI license. The free license allows you to build and publish reports for personal use, but automating and sharing them requires a Pro or Premium license.
2. Accessible Data Sources. Power BI Service needs to be able to reach your data sources to pull fresh data.

• If your data lives in a cloud source (like SharePoint, Azure SQL Database, or Google Analytics), the process is straightforward.
• If your data is stored on-premises (like in an Excel file on your local network drive or a SQL Server inside your company's firewall), you'll need an extra piece of software called an On-premises Data Gateway. We'll cover that in detail later.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step: Setting Up Scheduled Refresh for Cloud Data

If your data is already in the cloud, setting up a scheduled refresh takes less than five minutes. Here is the process, step by step.

Step 1: Publish Your Report to Power BI Service

First, you need to get your report from the Desktop application to the cloud service. Once your report is complete in Power BI Desktop, look for the Publish button on the Home tab of the ribbon.

When you click it, Power BI will ask you to select a destination workspace. A "Workspace" is just a folder in the Power BI Service for organizing your reports. Select the workspace where you want the report to live (like "Marketing Reports" or "My Workspace") and click "Select." Once it's done, you'll get a direct link to open the report in Power BI Service.

Step 2: Go to the Dataset Settings

In the Power BI Service, find your report in the appropriate workspace. You’ll notice that when you publish a report, Power BI also creates a corresponding dataset with the same name. It is the dataset, not the report itself, that handles the data connection and refresh schedule.

In the navigation pane on the left, find your workspace, hover over the dataset for your report, click the three dots (...), and then select Settings.

Step 3: Edit Your Data Source Credentials

On the Settings page, expand the Data source credentials section. Power BI Service needs your permission to access the data on your behalf. Previously, you connected from Power BI Desktop, but now the cloud service needs its own authenticated connection.

Click on "Edit credentials." You will be prompted to sign in to your data source. Since it's a cloud source like SharePoint or another Microsoft service, you will likely just need to select an authentication method (usually OAuth2 for cloud services) and log in with your account credentials. Once done, you'll see a small confirmation that the connection is successful.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Configure the Scheduled Refresh

Now for the final step. Expand the Scheduled refresh section under Data source settings. This is where you bring the automation to life.

Toggle the option to turn it on. You will then see several configuration options:

• Refresh frequency: Choose between Daily or Weekly.
• Time zone: Select the correct time zone to ensure the refresh happens when you expect it to.
• Time: Click "Add another time" to specify when the refresh should run. With a Pro license, you can add up to 8 daily refresh times. For Premium licenses, you can have up to 48. A common strategy is to schedule one in the early morning (e.g., 7:00 AM) so the data is fresh when the team starts their day.

Once you are happy with the schedule, simply click "Apply." That’s it! Your report will now update itself automatically according to the schedule you’ve set.

Handling On-Premises Data with a Gateway

What if your data isn't in the cloud? For files on a network drive or in a local database, Power BI Service needs a secure "bridge" to access them. That bridge is the On-premises Data Gateway.

Think of the gateway as a secure data pipeline. It is a free piece of software you install on a computer within your local network that is always turned on (like a server). The gateway authenticates with the Power BI Service and then "listens" for refresh requests. When your report needs an update, Power BI sends the query request to the gateway, which then fetches the data from your local source and sends it back to the cloud, all securely encrypted.

Step 1: Download and Install the Gateway

You can download the standard gateway directly from Microsoft's website. You need to install it on a machine that has access to your on-premises data source and is always on and connected to the internet. Do not install it on a laptop that you take home with you every day.

Step 2: Configure the Gateway

After installing, you will need to sign in with your Power BI account to register the gateway to your tenant. Give your gateway a descriptive name (e.g., "Marketing Dept Gateway") and create a recovery key. Save this key somewhere safe! You’ll need it if you ever have to migrate or restore the gateway.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Connect to the Gateway in Power BI Service

Head back to the dataset settings in Power BI Service. Under the Gateway and cloud connections section, you should now see the gateway you just installed.

You need to map your local data source to the corresponding cloud connection. To do so, you can add your data source to the gateway and provide the necessary credentials for the gateway to operate.

Step 4: Set the Refresh Schedule

Once the gateway is set up and your data source has been added, the rest of the process is exactly the same as for a cloud source. Open the Scheduled refresh section, set your desired frequency and time, and click "Apply." Your on-premises data will now refresh automatically.

Best Practices for Better Automated Reports

Setting up scheduled refreshes is a huge step forward. Here are a few tips to make it even more efficient:

• Check for Failures: In the dataset settings, you can check a box to "Send refresh failure notifications to me." This is highly recommended so you can quickly fix any issues, like an expired authorization token or changes at the data source.
• Choose the Right Frequency: Just because you can schedule 8 refreshes a day doesn't mean you should. Consider how often your source data actually changes. For daily sales figures, one refresh per day is perfect. For more dynamic data, a few more might be needed.
• Display the Last Refresh Date: It’s good practice to add a card visual to your report that shows users exactly when the data was last updated. You can do this with a simple DAX measure. Create a new measure with this formula: Last Updated = "Data last refreshed on " & FORMAT(NOW(), "mmmm d, yyyy \at h:nn AM/PM") This builds trust and adds context for your audience.
• Optimize Your Data Model First: Large, complex data models with lots of columns and messy data transformations will take longer to refresh and are more likely to fail. Before you set up the report, clean and optimize your queries in Power Query Editor to do an easier and much faster job of refreshing your report.

Final Thoughts

Setting up scheduled refreshes turns Power BI from a simple reporting tool into a true business intelligence engine. You free yourself from tedious manual updates and empower your team to make faster, smarter decisions using data that is always current and reliable.

While Power BI is fantastic for detailed internal analysis, connecting and weaving together scattered marketing and sales data from platforms like Google Analytics, Shopify, Facebook Ads, and Salesforce can be complex. For those platforms, we designed Graphed to simplify the disconnected nature of all your reporting efforts. Instead of configuring gateways and managing credentials across a dozen different connections, you can connect your sources in seconds and use simple natural language "show me my ad spend vs. revenue last month" to create real-time, cross-channel dashboards instantly, without any of the setup that bogs teams down.