Microsoft Power BI On Premise Server Installation

Install Power BI Report Server


Download Power BI Report Server

Download Power BI Report Server from the Microsoft Download Center.
There's also a free trial version. On the On-premises reporting with Power BI Report Server page, select Download free trial.

Before you install

Before you install Power BI Report Server, we recommend you review the Hardware and Software Requirements for installing Power BI Report Server.
 Important
While you can install Power BI Report Server in an environment that has a Read-Only Domain Controller (RODC), Power BI Report Server needs access to a Read-Write Domain Controller to function properly. If Power BI Report Server only has access to a RODC, you may encounter errors when trying to administer the service.

Power BI Report Server product key

You can get the product key for Power BI Report Server from two different sources:
  • Power BI Premium
  • SQL Server Enterprise Software Assurance (SA)
Read on for details.

Power BI Premium

If you have purchased Power BI Premium, within the Premium settings tab of the Power BI admin portal, you have access to your Power BI Report Server product key. This is only available for Global Admins or users assigned the Power BI service administrator role.
Premium settings
Selecting Power BI Report Server key displays a dialog contain your product key. You can copy it and use it with the installation.
Product key

SQL Server Enterprise Software Assurance (SA)

If you have a SQL Server Enterprise SA agreement, you can get your product key from the Volume Licensing Service Center.

Install your report server

Installing Power BI Report Server is straightforward. There are only a few steps to install the files.
You don't need a SQL Server Database Engine server available at the time of install. You will need one to configure Reporting Services after install.
  1. Find the location of PowerBIReportServer.exe and launch the installer.
  2. Select Install Power BI Report Server.
    Install Power BI Report Server
  3. Choose an edition to install and then select Next.
    Choose an edition
    You can choose either Evaluation or Developer edition from the drop down.
    Edition 2
    Otherwise, enter the product key that you got from either the Power BI service or the Volume License Service Center. For more information about how to get your product key, see the Before you install section above.
  4. Read and agree to the license terms and conditions, then select Next.
    License terms
  5. You need to have a Database Engine available to store the report server database. Select Nextto install the report server only.
    Install files only
  6. Specify the install location for the report server. Select Install to continue.
    Specify install path
    The default path is C:\Program Files\Microsoft Power BI Report Server.
  7. After a successful setup, select Configure Report Server to launch the Reporting Services Configuration Manager.
    Configure the report server

Configure your report server

After you select Configure Report Server in the setup, you're presented with Reporting Services Configuration Manager. For more information, see Reporting Services Configuration Manager.
You need to create a report server database to complete the initial configuration of Reporting Services. A SQL Server Database server is required to complete this step.

Creating a database on a different server

If you are creating the report server database on a database server on a different machine, you need to change the service account for the report server to a credential that is recognized on the database server.
By default, the report server uses the virtual service account. If you try to create a database on a different server, you may receive the following error on the Applying connection rights step.
System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group '(null)' not found. Check the name again.
To work around the error, you can change the service account to either Network Service or a domain account. Changing the service account to Network Service applies rights in the context of the machine account for the report server.
Configure report server service account
For more information, see Configure the report server service account.

Windows Service

A windows service is created as part of the installation. It is displayed as Power BI Report Server. The service name is PowerBIReportServer.
Report Server Windows Service
Report Server Windows Service properties

Default URL reservations

URL reservations are composed of a prefix, host name, port, and virtual directory:
PartDescription
PrefixThe default prefix is HTTP. If you previously installed a Secure Sockets Layer (SSL) certificate, Setup tries to create URL reservations that use the HTTPS prefix.
Host nameThe default host name is a strong wildcard (+). It specifies that the report server accepts any HTTP request on the designated port for any host name that resolves to the computer, including http:///reportserver, http://localhost/reportserver, or http:///reportserver.
PortThe default port is 80. If you use any port other than port 80, you have to explicitly add it to the URL when you open web portal in a browser window.
Virtual directoryBy default, virtual directories are created in the format of ReportServer for the Report Server Web service and Reports for the web portal. For the Report Server Web service, the default virtual directory is reportserver. For the web portal, the default virtual directory is reports.
An example of the complete URL string might be as follows:
  • http://+:80/reportserver, provides access to the report server.
  • http://+:80/reports, provides access to the web portal.

Firewall

If you are accessing the report server from a remote machine, you want to make sure you have configured any firewall rules if there is a firewall present.
You need to open up the TCP port that you have configured for your Web Service URL and Web Portal URL. By default, these are configured on TCP port 80.

Additional configuration

Next steps


 Reference 

https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server
Subscribe to: Posts (Atom)