How to Update Power BI Report Server

Keeping your Power BI Report Server up-to-date is one of those critical maintenance tasks that's easy to put off but essential for keeping your analytics engine running smoothly and securely. A successful update means access to the latest features, better performance, and crucial security patches. This guide will walk you through the entire process, covering everything from pre-flight checks and backups to the step-by-step update and post-install verifications.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Updating Power BI Report Server is a Good Idea

Before jumping into the "how," let's quickly cover the "why." You're not just clicking an "update" button for the sake of it. Each new release, which Microsoft typically ships three times a year (January, May, and September), brings tangible benefits that make the effort worthwhile.

Access to New Features and Visualizations

Each update brings a new set of features, many of which align with enhancements made to the Power BI service. This could include new DAX functions, updated visualization types (like new card visuals or slicer interactivity), mobile layout improvements, or more powerful formatting options. To use these new tools, both your server and the corresponding version of Power BI Desktop (for Report Server) need to be updated.

Critical Security Patches

Your Report Server often connects to and reports on some of your company's most sensitive data. Like any software, it can have vulnerabilities. Microsoft regularly includes security patches in its updates to protect your server and data from emerging threats. Staying on an old, unsupported version is like leaving a door unlocked - it's an unnecessary risk.

Improved Performance and Stability

With every release, the Power BI team includes bug fixes, performance optimizations, and stability improvements under the hood. An update might fix that one annoying rendering glitch you've been seeing, speed up model processing, or simply make the web portal more responsive. These incremental gains add up to a better experience for both you and your end-users.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Staying in Microsoft's Support Window

Microsoft offers mainstream support for each version of Power BI Report Server for one year. If you fall behind, you risk being in a position where you can no longer get official support if you run into a critical issue. Staying current ensures you're always on a version that the Microsoft team can help you with.

Before You Start: Your Pre-Update Checklist

A smooth update is all about preparation. Rushing into the installation without a proper plan can lead to unexpected downtime or, in a worst-case scenario, a corrupted report server. Spend 30 minutes on these checks to save yourself hours of potential headaches.

1. Read the Release Notes

Your first step should always be to read the release notes and the "What's New" blog post for the version you're upgrading to. Microsoft's documentation is excellent and will highlight new features, any deprecated functionality, and potential breaking changes you need to be aware of. You can usually find these with a quick search for "Power BI Report Server May 2024 what's new."

2. Verify System Requirements

While requirements don't change drastically between versions, it's always a good practice to double-check. Confirm that the server's OS, .NET Framework version, and available resources (RAM, CPU) still meet or exceed the requirements for the new version. This is particularly important if you're making a significant version jump.

3. Perform a Full Backup (This is Not Optional!)

If something goes wrong during the update, your backups are your only safety net. Don't skip this step. You need to back up two key components of your Report Server:

Back Up Your Databases

Your reports, data sources, subscriptions, and security settings are all stored in two SQL Server databases: ReportServer and ReportServerTempDB. Back these up using SQL Server Management Studio (SSMS) or a T-SQL script.

Make sure to replace the file path with your own backup location.

Back Up Your Encryption Key

This is arguably the most critical backup of all. The encryption key protects all the stored credentials for your data sources. If you have to restore your databases without this key, none of your reports will be able to connect to their data. You'll have to re-enter the credentials for every single data source manually.

• Open the Report Server Configuration Manager.
• Navigate to the Encryption Keys tab.
• Click the Backup button.
• Choose a secure location to save the key file (it will have a .snk extension).
• Create a strong password to protect the file. Store this password somewhere safe - if you lose it, the backup key is useless!

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

4. Communicate Downtime with Your Users

The update process requires stopping the report server services, which means the web portal will be unavailable. Plan your update during a maintenance window (like an evening or weekend) and communicate the expected downtime to your users. A simple heads-up prevents a flood of "the report server is down!" emails.

The Main Event: Step-by-Step Update Process

With your pre-flight checks and backups complete, you're ready to run the update. The process is a straightforward in-place upgrade, meaning you'll just install the new version over the old one.

Step 1: Download the Latest Version

Head to the official Microsoft Power BI Report Server download page. Download the executable file, typically named something like PowerBIReportServer.exe.

Important: There is a separate version of Power BI Desktop specifically optimized for Report Server. You will need to update this client tool as well, but do the server update first. We'll cover that in the post-update steps.

Step 2: Run the Installer

Now, log onto your Report Server machine with an administrator account and run the installer you just downloaded. The setup wizard is very user-friendly.

1. On the welcome screen, select Upgrade an existing report server installation. The installer will automatically detect your current Report Server instance.
2. Accept the license terms and privacy statement.
3. The next screen will ask for a product key. Since you are upgrading an existing installation, the installer should pre-populate this for you. If not, you'll need to enter the product key you received from your Volume Licensing agreement or SQL Server Enterprise Software Assurance.
4. Review the installation path. It should be pointing to your existing Report Server directory.
5. Click Install to begin the upgrade.

The installer will now do its work. It handles everything in the background: stopping the Report Server services, backing up existing files, installing the new files, updating the database schema, and restarting the services. This usually takes just a few minutes.

Step 3: Wait for Setup to Complete

Once you see the "Setup Completed Successfully" screen, you can close the installer. While the initial setup is done, don't walk away just yet. You still need to verify that everything is working as expected.

After the Update: Verification and Final Steps

Congratulations, your server is updated! But the job isn't finished until you've confirmed everything is running correctly. A few simple checks now will ensure your users have a seamless experience.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

1. Verify the Server Version

First, confirm that the update was successful. You can check the version in a couple of ways:

• Web Portal: Open your Report Server's web portal. Scroll down to the bottom of the page. You should see the updated version number displayed (e.g., "Microsoft Power BI Report Server Version 1.19.8779.17648 (September 2024)").
• Configuration Manager: Open the Report Server Configuration Manager. The version number is also displayed on the main status page for your instance.

2. Test Core Functionality

Take a few minutes to smoke test the environment:

• Navigate the Web Portal: Click through a few folders to make sure navigation is responsive.
• Open Reports: Open several key reports, especially a mix of Power BI reports (.pbix) and paginated reports (.rdl). Make sure they render correctly without any visual errors.
• Test Data Connectivity: Find a report with a live connection or a recent import schedule and try to refresh it manually. If the refresh succeeds, your datasource credentials and encryption key have successfully migrated.
• Verify Subscriptions: If you have any time-sensitive email subscriptions, it's a good idea to run one manually to confirm that the subscription processor is working correctly.

3. Update Power BI Desktop for Report Server

This is a critical final step that many people forget. Report creators on your team cannot publish reports to the newly upgraded server until they update their design tool. The version of Power BI Desktop for Report Server must match the server's update cycle.

Download the corresponding version from the same Microsoft download page. The file name will be something like PBIDesktopRS.msi. Distribute this installer to all of your report developers and have them upgrade their local installations. Without this, they won't be able to access the new features or publish their work.

Troubleshooting Common Update Issues

Most upgrades go smoothly, but here are a few common hiccups and how to handle them:

• Services Fail to Start: This is rare, but if the Report Server service doesn't start, check the Windows Event Log for detailed error messages. Often, it's a permission issue with the service account.
• Web Portal Doesn't Load: Try clearing your browser cache first. If it still doesn't load, restart the Report Server service via the Configuration Manager and check the server's application logs.
• "Encryption Keys Could Not Be Validated": This scary-sounding error typically means there's a mismatch. This is where your encryption key backup comes in. You can use the Configuration Manager to restore the key you backed up before the update.
• Specific Reports Fail to Render: If only a few reports are having issues, it's likely due to a breaking change or a compatibility issue with a custom visualization or data source. Go back and re-read the release notes - they often call out these changes.

Final Thoughts

Updating your Power BI Report Server is a straightforward but important process you should perform regularly. With careful planning, proper backups, and thorough verification, you can ensure a smooth transition that provides your organization with the latest BI features, performance, and security every time.

While maintaining on-premise servers is a reality for many, we understand that this kind of administrative overhead is exactly what many teams are trying to escape. That’s why we built Graphed. We wanted to eliminate the friction of server updates, version management, and manual reporting. Our platform connects directly to your cloud data sources - like Google Analytics, HubSpot, Salesforce, and Shopify - so you can go from data to dashboard in seconds by just describing what you want to see. Instead of scheduling maintenance windows, you can ask questions in plain English and get real-time answers, allowing you to focus on acting on insights, not managing infrastructure.