Legacy Content!

This configuration is based on the Microsoft Power BI Report Server October 2017 release, which is not officially supported by Microsoft anymore. (warning) As of LUCS 3.2, OLAP Server support for LUCS has ended, as Reporting and relevant Datamart accesses are handled directly within LUCS database.

(info) This page is legacy content.  → For the newest Approach using LUCS >= 3.2 head to Managing BI User and Data access.

Hardware and Software Requirements

The requirements for Power BI server are dictated by Microsoft.  When running the reporting Server on the same machine as your LUCS installation, consider reading the LUCS General Prerequisites as well. We recommend using separate machines or VM instances for reporting and LUCS to access for maintenance and updates as well as fewer potential performance impacts when either system is under heavy load.

Connect to the Power BI Report Server

  1. Login to the server where the Power BI Report Server has been installed.
  2. Open Report Server Configuration Manager

  3. Check the Server Name field and ensure the server where Power BI Report Server was installed is named. The Report Server Instance should also be the default PBIRS.

    Report Server Connection Dialog

  4. After the installation the "Report server" service should be started. If not, press "Start"

    Report Server Service


Configure the Service Account

  1. Click the Service Account tab from the menu.

    Screenshot of Service Account tab
  2. Depending on the Deployment Architecture chosen, complete case A or B:
    1. If Power BI Report Server and SQL Server are on different server go to Case A.
    2. If Power BI Report Server and SQL Server are on the same server go to Case B.

  3. Steps, according to your Case:

    Case ACase B

    Change the use built-in account to Network Service Account.

    Do not change the use built-in account (Default: Virtual Service Account)

  4. Press Apply and wait for the services to restart.

    Screenshot of Applying Report Server Service Account

Configure the Web Service URL

  1. Click the Web Service URL tab

  2. Configure custom values for the following fields or leave as default:

    SettingDescription
    IP AddressDefault is All Assigned (Recommended)
    TCP PortDefault is 80
    HTTPS CertificateDefault is (Not Selected)
    HTTPS Port:Default is Blank

    (info) More information has been provided by Microsoft in their SSRS documentation.

  3. Check the Web Service URL field to ensure it displays the expected value:

  4. Click Apply to save the configuration and wait for the services to restart.


Configure the Database

  1. Click the Database tab.
  2. Click Change Database

  3. Select ‘Create a new report server database’ and press ‘Next’

  4. Depending on the configuration choose between case A, B or C.

    1. Same SQL Instance, Default Names

    2. Same SQL Instance, Custom Names
    3. Different SQL Instance, Default Names

Case A - Same SQL Instance with Default Names

  1. Enter the connection details for the SQL Instance hosting LUCS.

    FieldDescriptionExample
    Server Name:The <ServerName> for the SQL Server hosting the LUCS database. Followed by the <SQLInstance> name hosting the LUCS database.SQL01\LUCS
    Authentication Type:How Power BI Report Server configurater will connect to the Report DatabaseCurrent User – Integrated Security
    Username:Domain and username for the account being used to connect to the SQL Server running the LUCS instanceDOMAIN\User1
    Password:Password of the user account-
  2. Test the connection to check the database is reachable and the permissions required are assigned.
  3. Press Next on the Enter Database Name configuration


  4. Enter the Credentials to use for the Report Server to access the Report Server Database. (tick) Use default unless a custom configuration is required.
  5. (info)  If a ‘Warning’ notification appears Press ‘OK’.


  6. Press Next to process the configuration.
  7. Press Finish to save the configuration and restart the PowerBI Services.Screenshot of Finalization stage


Case B: Same SQL Instance, Custom Names

  • This procedure is the same as Case A, however, when asked for the ReportServer database name, you specifiy a custom one. 

  • Suggestion  : "ReportServerPowerBI" (This will create the ReportServerPowerBI and ReportServerPowerBITempDB in the Instance of SQL selected).

  • Your result screen will look as follows: 



Case C:  Different SQL instance, default name

The same as Case A and B except when asked for the SQL instance you will specify your own one:

  1. Enter the connection details for the SQL Instance that will host the ReportServer and ReportServerTempDB databases.

    FieldDescriptionExample
    Server Name:The <ServerName> for the SQL Server that will host the ReportServer databases. Followed by the <SQLInstance> name that will contain the ReportServer databases.SQL01\POWERBI
    Authentication Type:How Power BI Report Server configurater will connect to the Report DatabaseCurrent User – Integrated Security
    Username:Domain and username for the account being used to connect to the SQL Server running the ReportServer databaseDOMAIN\User1
    Password:Password of the user account-

  2. Leave the ReportServer and ReportServerTempDB as default names by pressing Next
  3. Enter a custom name such as ReportServerPowerBI
    (info) This is only required if there are already databases within the SQL instance called ReportServer and ReportServerTempDB)
  4. Your result screen will look as follows: 


Configure the Web Portal URL

  1. Click the Web Portal URL tab
  2. Press Apply to accept the default configuration or use Advanced to choose a custom URL and Port.

    →  Configuration is now complete