At a Glance 

Introduction
What Why How…
Installation
Configuration

Introduction

The Power BI Report Server is a new, standalone product that allows organizations to host Power BI Reports on an on-premises report server. Additionally, the Power BI Report Server is built upon the same architecture as SQL Server Reporting Services, allowing you to also use the server to host paginated reports, mobile reports, and key performance indicators (KPIs), thus creating a “one-stop shop” for all your reporting assets.

What

Power BI Desktop as a powerful tool for self-service BI and creating interactive reports. It offers data warehouse capabilities, including data preparation, data discovery and interactive dashboards.

Self-service BI using Power BI provides the tools you need to find data, shape and filter it how you want, model it, and visualize. Data visualization is a quick and easy way to convey concepts or information in a universal manner. Data visualization can help to:

  • Analysis capabilities of business processes or activities
  • Get factors that give better insights.
  • Drive better decision making
  • Make proper predictions.
  • Providing an integrated view

Why

Power BI gives cloud-based BI services, known as “Power BI Services”, along with a desktop based interface, called “Power BI Desktop”. Sharing reports with business users the on-premises solution requirement arrived. On-premises solution to host Power BI Reports are required due to several reasons:

  • Complement the Power BI Service
  • Highly Regulated Customers
  • Integrate into existing investment in Reporting Services

Power BI reports in SQL Server Reporting Services combination of Power BI Desktop’s interactive report capability with SQL Server Reporting Services’ on-premises server platform.SQL Server 2017 will continue to include Reporting Services for on-premises enterprise reporting.Comparison view :

comparision

Source: SQL Server Reporting Services Team Blog

With Power BI Desktop and Power BI Report Server, you can

  1. Create beautiful, interactive reports using Power BI Desktop
  2. Publish reports to Power BI Report Server
  3. View and interact with reports in your web browser or in Power BI Mobile on your phone or tablet

How :

Power BI Report Server. With its small file size and simplified wizard, you can download and install Power BI Report Server in minutes. because it’s separate from SQL Server setup, you can install Power BI Report Server updates knowing they’ll have zero impact on your SQL Server deployments and databases.

The same Power BI reports you create for Power BI Report Server can work in the Power BI service and even continue to query your on-premises data via the On-premises Data Gateway.

Publish

Install Power BI Report Server

Power BI Report Server release notes : It’s better to take a look on release notes to

Hardware and software requirements: It’s an important to know & check the installation requirement from Microsoft site.

Download Free trial form Power BI site:

1. On-premises reporting with Power BI Report Server October 2017

  1. Power BI Desktop (October 2017)

  2. For Sample Data (if required to explore) you can download Dataware House WideWorldImporters database backup .

download file

Step 1 :Run the PowerBIReportServer file that you downloaded .Now you have to select the edition from the drop down.

p1

Step 2 :It’s simple installation steps within that step you have to agree Licencing teems , assign Installation path .

[gallery ids=”834,835,836,837” type=”rectangular” link=”file”]

Step 3 :After installation completion ,run the Report Server configuration manager to setting up ReportServer catalog database as well as confirm the web portal and web service URLs.

[gallery ids=”839,838,840” type=”rectangular” link=”file”]

Step 4: To get the Power BI Web portal Go to Browser > Write > http://localhost/reports

browse PBI_RS

Power BI reports on premises can store in Power BI reports Server or Power BI service (https://powerbi.com). You create and edit reports in Power BI Desktop, and publish them to the web portal. It can view able from browser or in a Power BI mobile app on a mobile device.

Power BI reports for Power BI Report Server:

Power BI Desktop optimized is required for Power BI Report Server. It’s important to remember that this one release is different from the Power BI Desktop used with the Power BI service.

Step 1: There is download link is in the Web portal.

PD1

Step 2: Now you have select the required installer .Installation steps are very easy.Main problem is that you have to careful on the version it should be October 2017.First time I’ve installed wrong version :( but Right one is “Optimized for Power BI Report Server - October 2017”.Download link has give on download section of above of  present article.

[gallery ids=”852,853,854,855,856,857,858,859” type=”rectangular” link=”file”]

It’s will better for new one to go through the article :

User handbook overview for Power BI Report Server

Hopefully this article objective is to help professionals. Have a nice day !