Installing Power BI Report Server

Thought I’d post my initial impressions of installing Power BI Report Server. Unless you’ve been disconnected from the web for any length of time, you’ve heard of Power BI. In May 2017, Microsoft released the Power BI Premium service tier, which includes the Power BI Report Server.

The home page will remind you of SSRS:


You have the option to install PBI Report Server as standalone service, or on the same server with SQL Server and/or SQL Server Reporting Services. In any event, you need to install PBI Report Server on a server running a SQL Server instance.

If you are familiar with the Power BI desktop software, there is a new PBI Desktop software you’ll need to install to work with PBI Report Server.

Here are the details and link:

Microsoft Power BI Report Server – June 2017 GA


Power BI Report Server, available as part of Power BI Premium, enables on-premises web and mobile viewing of Power BI reports, plus the enterprise reporting capabilities of SQL Server Reporting Services.

In this version of Power BI Report Server, you can:

  • Connect “live” to Analysis Services models – both Tabular and Multidimensional (cubes)
  • Visually explore data and create an interactive report
  • Use custom visuals in your Power BI Report
  • Save that report to your report server running the preview
  • View and interact with the report in your web browser
  • Add and view comments about the report in the web browser
  • View and interact with the report in the Power BI Mobile App

From <>

Let’s walk though an install of Power BI Report Server

Run PowerBIReportServer.exe, select install PBI Report Server


Choose evaluation version, unless you have the product key, click Next


Agree to license terms, click Next


You’re installing on a server with the database engine installed, click Next


Click Install


Monitor progress…


Installation complete.


Next up, configure report Server.

Connect to your local SQL Server instance


Note that once connected, your instance will be:



Next, click the Web Service URL on left and change name of VirtualDirectory to: ReportServerPBI (this allows SSRS to co-exist). Click Apply.


Click database, on left

Click Next


Click Test Connection to validate. If everything is fine, connection succeeded


Add a PBI suffix to the Database name (so it doesn’t over-write SSRS)

Click Next


Use default service credentials, click next


Review summary, click next


Completion dialog

Click Finish


Completed successfully


Click Web Portal URL on left, then add PBI suffix to Virtual Directory name, click Apply


Click the hyperlink shown the last dialog and it should take you to the Power BI Server.


Watch this blog for future updates on using the PBI Server and the new PBI Desktop software.

This entry was posted in Power BI Report Server, PowerBI, SQL, SQL Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.