How to Install Power BI Report Server

Setting up your own Power BI Report Server gives you the robust, interactive reporting capabilities of Power BI, all within the security of your on-premise infrastructure. This hands-on guide will walk you through the entire installation and configuration process, from downloading the right files to publishing your very first report to your new server.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding Power BI Report Server

Before jumping into the installation, let's quickly cover what Power BI Report Server is and why it might be the perfect solution for your organization. Think of it as your private, company-controlled version of the Power BI service.

What is Power BI Report Server?

Power BI Report Server is an on-premise server product that allows you to store, manage, and share Power BI reports, mobile reports, paginated reports (the traditional, printable format familiar to SSRS users), and KPIs directly on your company's network. It's the ideal solution when regulatory, security, or data sovereignty requirements prevent you from using a cloud-based service like the standard Power BI Service.

Key Benefits of Using the On-Premise Version

Choosing an on-premise solution comes with several distinct advantages that are particularly important for certain businesses:

• Data Governance and Security: This is the number one reason many organizations choose Report Server. When all your report data resides behind your own firewall, you maintain complete control over it, which is essential for industries like healthcare, finance, and government.
• Control Over Your Environment: Cloud services update automatically, sometimes leading to unexpected changes in features or functionality. With Report Server, you decide when to apply updates, allowing for thorough testing and a more predictable user experience.
• Potentially Lower Costs at Scale: Licensing can be managed through Power BI Premium capacity or as a benefit of having SQL Server Enterprise Edition with Software Assurance. For organizations already invested in the SQL Server ecosystem, this can be a very cost-effective way to deploy BI.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Before You Install: System Requirements and Prerequisites

Getting your components ready ahead of time will make the installation process much smoother. Here's a checklist of everything you'll need before you begin.

Licensing Done Right

First, you need a license to run Power BI Report Server in a production environment. You have two primary options:

• SQL Server Enterprise Edition with Software Assurance (SA): If your organization already has SQL Server Enterprise with SA, you're in luck! Power BI Report Server is included as a benefit. You can find your product key in the Volume Licensing Service Center.
• Power BI Premium: Purchasing Power BI Premium capacity (P or EM SKUs) also grants you a license to run Report Server.

Not ready to commit? You can install the Developer Edition for free, which is perfect for development and testing but not for production use.

Hardware & Software Requirements

Make sure your server meets these minimum requirements:

Hardware:

• Processor (CPU): A modern x64 processor (AMD Opteron/Athlon 64, Intel Xeon/Pentium IV with EM64T). At least 1.4 GHz or faster.
• Memory (RAM): At least 4 GB is recommended. More is always better, especially if you expect heavy usage.
• Disk Space: A minimum of 1 GB of available hard-disk space is required for the application itself. You will need additional space for the databases it creates.

Software:

• Operating System: Windows Server 2016, 2019, or 2022. You can also run it on Windows 10/11 for a non-production setup.
• .NET Framework: Version 4.8 or later will be required. The installer typically prompts you if it's not present.
• SQL Server Database Engine: This is essential. The Report Server needs a SQL Server instance to store its metadata, report definitions, and cached data. This can be running on the same server or on a different one. Supported versions range from SQL Server 2014 through 2022.

Step-by-Step Guide to Installing Power BI Report Server

With the prerequisites out of the way, it's time to roll up your sleeves and get to the installation. We'll break this down into three core stages: installing the server, configuring the databases, and verifying the installation.

Step 1: Download the Necessary Installers

Your first stop is the official Microsoft download page for Power BI Report Server. You need to grab two key files:

• PowerBIReportServer.exe: This is the actual server installer.
• PBIDesktopRS.exe: This is a special version of Power BI Desktop that is optimized to create reports specifically for Report Server. The regular Power BI Desktop from the Windows Store will not work correctly for this purpose.

Download both files and save them to a convenient location on your server.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Run the Server Installer

Double-click the PowerBIReportServer.exe file to launch the installation wizard. Here's what to expect on each screen:

1. Choose an Edition: Your first choice is the version to install. Select "Install a free edition" and pick "Developer" if you're exploring, or choose "Enter the product key" if you have one.
2. Accept License Terms: Read and accept the license terms to continue.
3. Select Installation Option: The wizard will present an option to "Install Power BI Report Server only." Select this option. This is the recommended approach because it separates the installation from the configuration, giving you much more control.
4. Specify Install Location: Choose the destination folder for the server files. The default location is usually fine.

Once you click "Install," the files will be copied to your server. When it's finished, the wizard will display a "Setup Completed" message with a button to "Configure Report Server." Go ahead and click it.

Step 3: Crucial Configuration with Report Server Configuration Manager

This is the most hands-on part of the process, but don't worry - the Configuration Manager tool makes it straightforward. This is where you connect the server application to the SQL Server database that will act as its brain.

1. Connect to Your Server: The Configuration Manager will open automatically. Click "Connect" to connect to the Report Server instance you just installed. On the left pane, you'll see a list of configuration items. We'll go through the most important ones.
2. Web Service URL: This is the backend URL applications use to talk to your server. Click on this section in the left pane. In the main window, you just need to click "Apply" to accept the defaults. This will set up a URL like http://YourServerName/ReportServer. Look for the "The URL was reserved successfully" message.
3. Database: This is KEY! The server is useless without its database home.
4. Web Portal URL: This is the user-facing web portal everyone will use to access reports.
5. Verify: Click the link in the Web Portal URL section. Your default browser should open and display the Power BI Report Server web portal home page. If you see it, congratulations! Your server is installed and running correctly.

Installing the Right Tools for Report Authoring

The server is ready, but now you need the tool to create and publish reports. This is where that second file you downloaded, PBIDesktopRS.exe, comes into play.

Installing Power BI Desktop for Report Server

Installation is simple: just double-click PBIDesktopRS.exe and follow the standard "Next, Next, Finish" wizard. The result will look and feel almost identical to the regular Power BI Desktop.

The Golden Rule: Always use this version of Power BI Desktop when creating reports that will be published to your On-Premise Report Server. The features in this version are tailored to match the capabilities of your server release, ensuring compatibility and preventing errors during publishing.

Graphed

Still Building Reports Manually?

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

Watch the Demo

(Optional) Installing Microsoft Report Builder

If your team also needs to create paginated reports - those pixel-perfect, detailed reports designed for printing or PDF exports - you'll need to install Microsoft Report Builder. You can find a download link for it directly from your Report Server's web portal in the download menu.

Publishing Your First Report to the Server

Let's complete the final step and see your work in action.

1. Create a Simple Report: Open Power BI Desktop (for Report Server). Create a quick report - you can use the "Enter Data" feature to make a small table quickly or connect to any local data source like an Excel file. Drop a visual onto the canvas, like a bar chart.
2. Save to Report Server: Instead of the normal "Save As," navigate to File > Save as > Power BI Report Server.
3. Connect and Publish: A dialog box will appear. You will need to click on "Account Settings" towards the bottom right of the page and enter the Web Portal URL you configured earlier (e.g., http://YourServerName/reports). Once connected, you can browse to a server folder (like the Home folder), give your report a name, and click "Save."
4. View Your Published Report: Refresh the web portal in your browser. You will now see your report file listed. Click on it, and it will render interactively right there in your browser!

Final Thoughts

This tutorial covers the primary steps for a functional on-premise Power BI installation - from downloading the files to running the installer, using the Configuration Manager to link your SQL Server database, and finally publishing a report with the special version of Power BI Desktop. While there are deeper configurations possible involving security and custom branding, you are now equipped with a solid and working Power BI Report Server.

While an on-premise set-up like this offers excellent control, it also carries the overhead of server management and maintenance. We built Graphed because we believe achieving powerful insights should be less about IT infrastructure and more about asking the right questions. Instead of managing servers, you can connect cloud sources like Google Analytics, Salesforce, and Facebook Ads in minutes and create real-time reports just by describing what you need in plain English - no configuration files needed.