Power BI On-Premises Server Installation And Configuration

By default it will create local host machine name as Web service URL, Click apply to configure default URL. If you want you can change the virtual directory name.



Step 10

Create new server database or you can use existing SSRS report database.

I like to maintain different database for SSRS and Power BI so I am creating different database for Power BI



Step 11

Select SQL Server Instance where you want to create Power BI report server database, Select Authentication type and enter account details which should have necessary permission to create database in SQL Server instance.



Give Database name

Basically SQL Server creates two databases -- one is report server database and another one is report server temp database



Configure the Account which should be used to connect SQL Server Database.

It is recommended to use service account which should have full permission to newly created report server database.



Step 12

Configure web portal URL, you can also use the default web portal URL. Click apply to configure the URL.

Click on the web URL to see the report manager.



Step 13

To develop power BI Reports you have to install Power BI Desktop report server which is designed to develop and publish power BI reports in on premises server.

Double click on PBIDesktopRS_x64.msi then follow the below steps to install power BI Desktop











Sample Report

Open Power BI Desktop and develop new report then save report in the Power BI Report server.