This configuration is based on the Microsoft Power BI Report Server October 2017 release, which is not officially supported by Microsoft anymore. As of LUCS 3.2, OLAP Server support for LUCS has ended, as Reporting and relevant Datamart accesses are handled directly within LUCS database.
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
- Login to the server where the Power BI Report Server has been installed.
- Open Report Server Configuration Manager
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
After the installation the "Report server" service should be started. If not, press "Start"Report Server Service
Configure the Service Account
Click the Service Account tab from the menu.Screenshot of Service Account tab
- Depending on the Deployment Architecture chosen, complete case A or B:
- If Power BI Report Server and SQL Server are on different server go to Case A.
- If Power BI Report Server and SQL Server are on the same server go to Case B.
Steps, according to your Case:
Case A Case B
Change the use built-in account to Network Service Account.
Do not change the use built-in account (Default: Virtual Service Account)
Press Apply and wait for the services to restart.Screenshot of Applying Report Server Service Account
Configure the Web Service URL
- Click the Web Service URL tab
Configure custom values for the following fields or leave as default:
Setting Description IP Address Default is All Assigned (Recommended) TCP Port Default is 80 HTTPS Certificate Default is (Not Selected) HTTPS Port: Default is Blank
More information has been provided by Microsoft in their SSRS documentation.
Check the Web Service URL field to ensure it displays the expected value:
Click Apply to save the configuration and wait for the services to restart.
Configure the Database
- Click the Database tab.
- Click Change Database
- Select ‘Create a new report server database’ and press ‘Next’
Depending on the configuration choose between case A, B or C.
Same SQL Instance, Default Names
- Same SQL Instance, Custom Names
- Different SQL Instance, Default Names
Case A - Same SQL Instance with Default Names
Enter the connection details for the SQL Instance hosting LUCS.
Field Description Example 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 Database Current User – Integrated Security Username: Domain and username for the account being used to connect to the SQL Server running the LUCS instance DOMAIN\User1 Password: Password of the user account -
- Test the connection to check the database is reachable and the permissions required are assigned.
- Press Next on the Enter Database Name configuration
- Enter the Credentials to use for the Report Server to access the Report Server Database. Use default unless a custom configuration is required.
- If a ‘Warning’ notification appears Press ‘OK’.
- Press Next to process the configuration.
- 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:
Enter the connection details for the SQL Instance that will host the ReportServer and ReportServerTempDB databases.
Field Description Example 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 Database Current User – Integrated Security Username: Domain and username for the account being used to connect to the SQL Server running the ReportServer database DOMAIN\User1 Password: Password of the user account -
- Leave the ReportServer and ReportServerTempDB as default names by pressing Next
- Enter a custom name such as ReportServerPowerBI
This is only required if there are already databases within the SQL instance called ReportServer and ReportServerTempDB)
- Your result screen will look as follows:
Configure the Web Portal URL
- Click the Web Portal URL tab
- Press Apply to accept the default configuration or use Advanced to choose a custom URL and Port.
→ Configuration is now complete