How to Upgrade Power BI Report Server

Upgrading your Power BI Report Server is a critical maintenance task that unlocks new features, enhances security, and keeps your reporting environment running smoothly. Getting it done doesn't have to be a complicated or intimidating process. This guide provides a clear, step-by-step walkthrough to ensure your upgrade is successful and stress-free.

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

First Things First: Why Upgrade?

You might be wondering if it's worth the effort. In most cases, the answer is a resounding "yes." Each new release of Power BI Report Server rolls out valuable improvements, such as:

• New Features and Visuals: Microsoft regularly adds new chart types, formatting options, and functionality that can make your reports more insightful and visually appealing.
• Performance Improvements: Upgrades often include optimizations that can make report loading and data processing faster.
• Security Patches: Keeping your server updated is one of the best ways to protect your reporting environment from potential vulnerabilities.
• Bug Fixes: Pesky glitches from previous versions get ironed out, leading to a more stable experience for you and your end-users.
• Compatibility: An upgrade ensures you’re running a supported version and can use the latest version of Power BI Desktop for Report Server.

The Pre-Upgrade Checklist: Your Recipe for Success

A little preparation goes a long way. Before you even think about running the installer, take a few minutes to go through this checklist. This is the single most important phase for preventing headaches and data loss.

1. Check the System Requirements

Don't assume your current server meets the needs of the new version. Check the official Microsoft documentation for the latest Power BI Report Server release to confirm hardware and software requirements. Pay close attention to supported Windows Server versions and required .NET Framework versions.

2. Download the Correct Files

You'll need two main downloads:

• Power BI Report Server: Get this directly from the Microsoft download page. Be sure to select the correct edition for your license (e.g., you'll need a Power BI Premium or SQL Server Enterprise Software Assurance license for production).
• Power BI Desktop (Optimized for Report Server): You must use the specific version of Power BI Desktop that corresponds to your report server release. This is a separate download from the standard Power BI Desktop used for the Power BI service. Authors can only publish reports created with this version. You can find this on the same download page under "Advanced download options."

3. The Golden Rule: Back Everything Up!

If you do nothing else, do this. An upgrade process modifies your report server database, and a full backup is your only safety net if something goes wrong. You absolutely need to back up two critical components:

Back Up the Report Server Databases

Using SQL Server Management Studio (SSMS), connect to the database instance hosting your report server databases. By default, these are named ReportServer and ReportServerTempDB. Perform a full backup for both.

Back Up the Encryption Key

The encryption key is used to secure sensitive information like stored data source credentials. Without it, you cannot restore and access that information from a database backup. To back it up:

1. Open the Report Server Configuration Manager on your server.
2. Connect to your Report Server instance.
3. In the left pane, navigate to the Encryption Keys tab.
4. Click the Backup button.
5. Choose a secure location to save the key file (.snk).
6. Create a strong password to protect the file. Store this password in a safe place - you will need it to restore the key!

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

4. Plan for Downtime

The upgrade process will require a brief service outage while the installation runs and the databases are updated. Inform your users in advance and schedule the upgrade during a low-traffic period, like a weekend or after business hours, to minimize disruption.

5. Verify Your Permissions

Ensure that you'll be running the upgrade with local administrator privileges on the server and system administrator (sysadmin) permissions on the SQL Server instance hosting the report server databases.

The Main Event: Step-by-Step Upgrade Guide

Once you’ve completed your pre-flight checklist, you’re ready to begin the upgrade. The process itself is surprisingly straightforward, as the installer handles most of the heavy lifting.

Step 1: Run the Installer

Locate the PowerBIReportServer.exe file you downloaded and double-click to launch it. If prompted by User Account Control, click "Yes."

Step 2: Choose to Upgrade

The installer's welcome screen will give you a few options. Since you already have a version installed, you'll want to select Upgrade Power BI Report Server.

Step 3: Accept License Terms

Review the product key and license terms. You likely won’t need to enter your product key as the installer typically detects the edition you're upgrading. Select the acknowledgment checkbox and click Next.

Step 4: Review and Begin Upgrade

The wizard will show an Upgrade page, confirming the instance that is about to be upgraded. Simply click the Upgrade button to kick things off.

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

Step 5: Patiently Wait

The installer will now begin the upgrade. It will stop the Report Server services, replace the old program files with the new ones, update the database schema, and then restart the services. You can monitor the progress on the screen.

Step 6: Finish the Installation

Once the components are successfully updated, you'll see a 'Setup Completed' screen. At this point, the core server upgrade is done. You can choose to open the Report Server Configuration Manager immediately or just click Close to exit the installer.

After the Upgrade: Verification and Cleanup

Your work isn’t quite done yet. A few post-upgrade checks are essential to confirm everything is working as expected.

1. Check the Configuration

Open the Report Server Configuration Manager. Take a moment to review the key sections (Service Account, Web Service URL, Database, Web Portal URL). The upgrade should have preserved all your previous settings, but it's always good practice to verify everything looks correct.

2. Test the Web Portal

Open your web browser and navigate to your Power BI Report Server web portal URL. Check that the page loads correctly and that you can browse through your folders and reports.

3. Test a Few Reports

Select a variety of reports (both Power BI reports and paginated reports, if you have them) and open them. Refresh the data and interact with slicers or filters to ensure they are rendering and functioning correctly.

4. Upgrade Power BI Desktop

For any user who creates and publishes reports, you now need to uninstall their old version of Power BI Desktop (Optimized for Report Server) and install the new version you downloaded earlier. This step is mandatory, as older versions of Power BI Desktop cannot publish to a newer version of Report Server.

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

5. Notify Your Team

Once you’ve confirmed everything is in working order, send out a communication to let your users know the upgrade is complete and the service is available again.

Troubleshooting Common Issues

While the process is generally reliable, you might occasionally hit a snag. Here are a couple of common issues and how to approach them:

Issue: The Web Portal Won’t Load (HTTP 404 or 503 Error)

Solution: This often points to an issue with URL reservations or service startup. First, check the Report Server Configuration Manager to see if the service is running. If it is, try stopping and starting the service from the "Status" tab. You can also try deleting an existing URL reservation and adding it back.

Issue: The Upgrade Failed

Solution: In rare cases, the database portion of the upgrade might fail. You will find details in the Report Server log files, typically located at \Microsoft SQL Server<version>\Reporting Services\LogFiles. The logs should point to where the error occurred - often related to database permissions or disk space. This is where having backups is crucial.

Final Thoughts

Upgrading Power BI Report Server is a straightforward task when broken down into manageable steps. By preparing and following these steps, you can ensure a smooth transition and take full advantage of the new capabilities the update offers. Managing an on-premises server, while powerful, comes with its own set of responsibilities. Regular updates are critical to maintain security and optimize functionality. Using a platform like Graphed can simplify the task. With strong integration, you can efficiently manage your server tasks, ensuring your reporting capabilities continue to align with your organizational needs.