How to Schedule Refresh in Power BI Report Server

Keeping your Power BI reports fresh is non-negotiable for making timely decisions, but manually hitting the refresh button is an absolute time-killer. If you're running your reports on-premises with Power BI Report Server, you have a powerful way to put this tedious task on autopilot. This guide will walk you through exactly how to set up, manage, and troubleshoot a scheduled refresh for your reports.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Understanding Scheduled Refreshes in Power BI Report Server

First, it's important to know that refreshing data in Power BI Report Server works differently than in the cloud-based Power BI Service. While the Service relies on on-premises data gateways to connect to your local data sources, Report Server connects to them directly since it's already inside your network. This makes the setup a bit more straightforward in some ways.

The entire process relies on a few key components working together:

• Power BI Desktop (Report Server version): This is where you build your report, define your data model, and choose your connection type (Import or DirectQuery). Critically, scheduled refresh is designed for reports using Import mode, where a snapshot of the data is loaded into the report file itself.
• Power BI Report Server: The on-premises platform where you publish, share, and manage your Power BI reports. The web portal is where you'll configure the refresh schedule.
• Your Data Sources: These are the databases (like SQL Server), files, or other sources where your actual information lives. The Report Server needs access to these to pull in new data.
• SQL Server Agent: This is the unsung hero of the process. Power BI Report Server uses the SQL Server Agent, a component of SQL Server, to run scheduled jobs. Your refresh plan is essentially a job that the Agent executes at the times you define. If the Agent isn't running, your scheduled refreshes won't work.

Prerequisites: What You Need Before You Start

Before you get into the settings, make sure you have everything in place to avoid hitting a wall later. Here’s a quick checklist:

• You have Power BI Desktop optimized for Power BI Report Server installed.
• The report you want to refresh is built using Import mode. DirectQuery reports don't need a scheduled data refresh because they query the data source live every time a user interacts with the report.
• You have permissions to publish and manage reports on your Power BI Report Server instance.
• You have valid credentials (like a username and password) to access your underlying data sources. Using a dedicated service account is highly recommended over personal credentials for stability.
• The Power BI Report Server machine can communicate with your data sources over the network. Firewalls or network issues can often block these connections.
• Your SQL Server Agent service, connected to the database that hosts the Report Server catalog, must be running. If you're not a database administrator, you might need to coordinate with your IT or DBA team to confirm this.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Preparing Your Report and Connecting to Data

The journey to a successful refresh starts in Power BI Desktop. The Report Server needs explicit instructions on how to access your data on its own, without you being there to enter a password.

Designing for Import Mode

Open your report in Power BI Desktop. If you plan to schedule a refresh, your report must use Import mode for the data sources you want to update. You can check this in the Power Query Editor. Import mode takes a copy of the data and stores it within the PBIX file. This is why it needs a scheduled refresh - to update that stored copy with the latest information from the source.

While building your report, try to be efficient with your data model. Only bring in the columns and tables you absolutely need. The bigger the data model, the longer the refresh will take and the more memory it will consume on your server.

Publishing to the Report Server

Once your report is ready, you need to publish it. This is a simple process directly from Power BI Desktop:

1. Go to File > Save As > Power BI Report Server.
2. Enter the web portal URL for your server (e.g., http://your-server-name/reports).
3. Choose the folder on the server where you want to store the report and give it a name.
4. Click OK.

Now your report is live on the server, but it's just a static snapshot. Let's make it dynamic.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 2: Configuring Data Source Credentials

This is the single most common point of failure for scheduled refreshes. After you publish the report, you must configure the credentials that the server will use to connect to your data source. Without this, the server has no way to access the data when it's time for a refresh.

1. Open your web browser and navigate to your Power BI Report Server portal.
2. Find the report you just published. Click the ellipsis (...) next to its name and select Manage from the dropdown menu.
3. On the management screen, click on the Data sources tab along the left navigation pane.
4. You will see a list of all data sources used in your report. For each one, you need to provide credentials. Select a data source to expand its options.
5. You’ll see different connection types. For a scheduled refresh, you want to select "Connect using the following credentials."
6. Enter the appropriate credentials. This would typically be a Windows username and password or a specific Database username and password, depending on your source. Again, using a dedicated service account here is best practice. If you use your personal account and your password changes, the refresh will fail.
7. After entering the credentials, click the Test Connection button. You should see a "Connection successful" message. If not, double-check your credentials, network access, and that the data source is online before proceeding.
8. Click Save to store the credential settings.

Step 3: Creating a Scheduled Refresh Plan

With credentials squared away, you can now tell the Report Server when to refresh the data. This is done by creating a refresh plan.

1. While still in the Manage section for your report, click on the Scheduled refresh tab on the left.
2. Click the + New scheduled refresh plan button. This will open the configuration page.
3. Give It a Description: First, add a simple description like "Daily Sales Data Refresh" so you can easily identify it later.
4. Choose a Schedule Type: You can select a Specific Schedule, which is most common, or a Shared Schedule. A shared schedule is an admin-defined schedule that can be reused across multiple reports (e.g., "Run after nightly ETL completes"). For most cases, you'll create a specific one.
5. Define the Cadence: You can configure the refresh to run at various intervals:
6. Set Start and End Dates: Optionally, set specific dates for the schedule to begin and end. This is useful for reports tied to a specific project or fiscal period.
7. Once you're happy with the timing, click the Create scheduled refresh plan button to save it.

That's it! Your report is now scheduled to refresh automatically.

Step 4: Monitoring and Troubleshooting Your Schedule

Setting up the schedule is half the battle, ensuring it runs smoothly is the other half. The Report Server portal gives you the tools to monitor its status.

Checking Refresh Status

1. Back in the Scheduled refresh tab for your report, you will now see your newly created plan listed. The key columns to watch are:

If you see a successful message here, you're good to go. If it failed, you'll need to do some detective work.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Common Refresh Errors and Fixes

If a refresh fails, the cause is usually one of a few common culprits:

• Stored Credentials Failure: This is an easy fix. A password changed, or the account was locked out. Just go back to the Data Sources tab, update the credentials, and test the connection again.
• SQL Server Agent Service Is Stopped: Your schedule is configured correctly but the report never leaves a "New" status or seems to be ignored. This is a classic sign that the SQL Server Agent isn't running. You'll need to contact your DBA or server admin to get it started.
• Source Database Connection Error: The error message might mention a timeout or network-related issue. This means the Report Server couldn't reach the database at all. Check that the source database is online and that there isn't a firewall blocking the connection.
• Server Resource Exhaustion: For very large Power BI datasets, the refresh process can consume a lot of CPU and RAM. If the Report Server runs out of memory during a refresh, it will fail. The solution might involve optimizing your data model in the PBIX file to be smaller or increasing the memory available on the server.

Final Thoughts

Setting up an automated refresh in Power BI Report Server is a fantastic way to streamline your reporting workflow, ensuring your stakeholders always have access to current data. By carefully configuring your data source credentials and creating a logical schedule, you can eliminate manual updates and gain back valuable time to focus on analysis rather than repetitive tasks.

While automated refreshes in Power BI are a huge step forward, we believe getting insights from your cloud data sources can be even simpler. At Graphed, our goal is to eliminate all the technical friction of reporting. We built Graphed to connect directly to your apps like Google Analytics, HubSpot, and Shopify, so your dashboards are always live and update in real-time. There are no schedules to configure or agents to check - just connect your accounts once and start asking questions in plain English to get the answers and visuals you need instantly.