How to Configure Power BI Report Server

Setting up Power BI Report Server gives you the power of Power BI's interactive reports and dashboards, but hosted within your own on-premises environment. This article provides a complete walkthrough, guiding you step-by-step through the installation and configuration process to get your own report server up and running smoothly.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is Power BI Report Server?

Power BI Report Server is an on-premises report server that comes with a web portal where you can display and manage reports and KPIs. It allows you to build a hybrid BI environment: one foot in the cloud with Power BI Service and one on-premises with Report Server. Many organizations choose this path for compliance, data governance, or security reasons, as it keeps all an organization's BI assets behind the corporate firewall.

Unlike Power BI Service, which is a cloud-based SaaS (Software as a Service) offering, Report Server is software you install and manage on your own servers. This gives you complete control over your hardware and data. It hosts Power BI reports (.pbix files), paginated reports (.rdl files), and Excel workbooks.

In essence, it’s a modern replacement and evolution of SQL Server Reporting Services (SSRS). If you're familiar with SSRS, you'll feel right at home with Power BI Report Server's architecture, though the capabilities are greatly enhanced with interactive Power BI reports.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Before You Begin: Prerequisites

Before jumping into the installation, you need to make sure your environment meets the necessary hardware and software requirements. Getting this right from the start will save you a lot of trouble down the line.

Software Requirements:

• Windows Server: Windows Server 2016, 2019, or 2022 is recommended. Windows 10/11 will also work for development or test environments.
• SQL Server Database Engine: The report server needs a SQL Server instance to host its databases (ReportServer and ReportServerTempDB). Supported versions include SQL Server 2014 or later. For best performance and full feature compatibility, using a recent version like SQL Server 2019 or 2022 is ideal. Note: This does not need to be installed on the same machine as the Report Server.
• SQL Server Agent: The SQL Server Agent service must be running on the instance hosting the report server databases. It handles scheduled operations like report subscriptions and data refresh schedules.
• .NET Framework: You'll need .NET Framework 4.8 or later installed on the server.
• Power BI Desktop (optimized for Power BI Report Server): This is a special version of Power BI Desktop. You must use this specific version to create reports that you intend to publish to the Report Server. You can download it directly from the Power BI Report Server web portal after installation.

Hardware Requirements (Minimum):

• Processor: At least one x64 processor (e.g., AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support). A dual-core 2.0 GHz or faster processor is recommended.
• RAM: At least 4 GB of RAM is required. For production environments, 16 GB or more is highly recommended, especially if you expect heavy usage.
• Hard Disk Space: At least 10 GB of available hard-disk space for the application and its components.

Step 1: Installing Power BI Report Server

Once you have your prerequisites in place, the installation process is quite straightforward. Power BI Report Server is licensed through either Power BI Premium or SQL Server Enterprise Edition with Software Assurance.

Here are the steps to follow:

1. Download the Installer: Go to the Microsoft Power BI Report Server download page and get the installation file (PowerBIReportServer.exe).
2. Run the Executable: Launch the installer as an administrator.
3. Choose an Edition: On the first screen, you'll be asked to choose an edition. You can install a free edition (Developer or Evaluation) or enter a product key for a licensed version. If you have a Power BI Premium or SQL Server Enterprise SKU, you can find the appropriate product key from the volume licensing service center or from Power BI itself. For this guide, we'll proceed with the free Evaluation edition which is fully featured for 180 days.
4. Accept Terms and Install: Read and accept the license terms, choose "Install Power BI Report Server only," and click Next. Choose an installation location or leave the default, then click Install.

And that’s the first part done! The server files are now on your machine. But don't stop here, the most important work is still ahead: configuring the server.

Step 2: Configuring with the Report Server Configuration Manager

After the installation finishes, you’ll see an option to "Configure report server." Clicking this will launch the Report Server Configuration Manager, which is the central hub for setting up your server. If you closed the installer, you can find it in your Start Menu.

When you start the Configuration Manager, it will ask you to connect to your installed server instance. It should be pre-populated, so just click "Connect."

Here’s how to work through each essential section on the left-hand navigation pane:

Graphed

Still Building Reports Manually?

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

Watch the Demo

Service Account

This is the account under which the Report Server Windows service will run. You have a few options:

• Use a domain user account: This is the recommended practice for production environments, especially if your SQL Server database is on another machine. You'll need to create a specific domain account for this purpose.
• Use a built-in account: For simpler setups or developer machines, you can select 'Virtual Service Account' or 'Network Service'. These are suitable when the database server is on the same machine.

Choose an account, enter credentials if necessary, and click Apply.

Web Service URL

This is the backend URL for your report server. It's the service endpoint that tools like Power BI Desktop will use to communicate with the server. Configuration is simple:

1. Click on the Web Service URL tab.
2. Defaults are usually fine here (/ReportServer as the virtual directory, Port 80, etc.).
3. Click Apply to create the URL reservation. You should see a success message and can click the URL to test it - it should open a basic web page displaying the directory.

Database

This is arguably the most critical step. Here, you'll configure the two databases the Report Server needs to function: ReportServer and ReportServerTempDB.

1. Navigate to the Database page and click Change Database.
2. Choose "Create a new report server database" and click Next.
3. Database Server: Enter the name of your SQL Server instance (e.g., MACHINENAME\SQLEXPRESS or just MACHINENAME if it's the default instance). You can use the "Test Connection" button to verify everything is working. Click Next once it's successful.
4. You'll then configure the Database Name (leave the default ReportServer). Leave the language as is. Click Next.
5. Credentials: Specify the account the report server will use to connect to its database. "Service Credentials" is fine for most cases if you set up the service account correctly and it has permissions (it should, as the wizard will grant them). Click Next.
6. Review the summary and click Next. The wizard will create the databases, tables, and permissions needed. You should see a success message on the Progress and Finish page.

Web Portal URL

This is the front-end, user-facing URL where people will go to browse, run, and manage reports. It replaces the old Report Manager from previous versions of SSRS.

1. Go to the Web Portal URL tab.
2. Review the Virtual Directory, which is typically /Reports.
3. Click Apply to configure the portal.
4. Once it’s done, you can click the URL to open it. This will take you to your shiny new Power BI Report Server web portal!

At this point, your server is officially configured and ready for business. You might also want to look at optional settings like Email Settings (for enabling report subscriptions) and Power BI Service Integration (to pin items to a Power BI cloud service).

Step 3: Uploading Your First Power BI Report

A configured server isn't much fun without reports. Here’s how you can publish your first Power BI report.

1. Create a Report in the Right Tool

Remember that you must use Power BI Desktop for Power BI Report Server. It's a separate install from the standard Power BI Desktop used for the Power BI service.

• Open the Report Server version of Power BI Desktop.
• Create a simple report by connecting to a data source (like a simple Excel file). For example, create a bar chart of sales by region.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Save to the Report Server

Instead of "Publish," you'll be using "Save As."

• Go to File > Save As.
• Select "Power BI Report Server."
• You'll be prompted to enter your Report Server address. Use the Web Service URL you configured (e.g., http://yourservername/ReportServer).
• Provide a name for the report (like "My First Report") and select a location on the server to save it (e.g., the Home folder).
• Click OK.

3. View it in the Web Portal

Now, navigate back to your Web Portal URL (e.g., http://yourservername/reports) in your browser. You should see your newly uploaded report listed on the main page. Click on it, and it will render interactively, right in your browser, served entirely from your own machine.

Final Thoughts

Configuring Power BI Report Server takes a bit of planning, but following the steps in the Configuration Manager makes it a systematic process. By setting up the service account, URLs, and database connections correctly, you create a powerful, self-hosted BI platform that gives you total control over your data and infrastructure.

If managing on-premises servers feels disconnected from the speed modern teams need, there’s a much simpler way. Here at Graphed, we've built a platform that removes the complexity of server setup or manual reporting. Instead of configuring databases and URLs, you simply connect your cloud data sources like Google Analytics, Shopify, and Salesforce in a few clicks. With our service, you can use plain English to build real-time dashboards and reports instantly. You get the insights you need in seconds, all without becoming a server administrator - we handle all the infrastructure so you can focus on growing your business. Give Graphed a try and see how easy data analysis can be.