Tips For a Successful Power BI Report Server Implementation

What is the Power BI Report Server

Power BI Report Server provides a unified approach and knowledge for those BI Analysts eager to use all the varied reporting options that Microsoft makes available in their Business Intelligence suite. It combines the normal paginated reports from Reporting Service with KPIs, Mobile Reports, and Power BI dashboards and reports. The key here is of these options are available on-premise which provides you the power to stay “your” data and related reports in-house.

Power BI Report Server (PBIRS) may be a superset of SQL Server Reporting Services (SSRS), itself a mature BI technology that has been a key component of the Microsoft BI stack for 15+ years. The main difference between the 2 platforms is that PBIRS brings with it Power BI reports, providing a contemporary BI experience to on-premises implementations.

As is that the case with any enterprise BI product, careful planning and consideration of how the technology are getting to be leveraged should be made up-front. This will help avoid speed bumps during implementation and ensure a smooth ride as you roll out your BI and analytics solutions. Whether you’ve been working with PBIRS from day one, or are beginning to use the platform for the primary time, the goal of this post is to showcase tips and techniques that you simply can rotate and apply in your own environment.

Configure Your Report Server

After installing your report server, you ought to consider reviewing a number of the default configurations. We’re not pertaining to configurations found within the Reporting Services Configuration Manager, but rather the advanced properties you'll tweak from within SQL Server Management Studio (SSMS). For many implementations, the default values of those properties are going to be fine. However, there could also be some specific use cases for once you would want to vary a setting. The advanced properties in PBIRS are like Power BI Service’s tenant settings within the Admin portal.

First, to look at the advanced properties dialog, you would like to attach to your report server from SSMS.

From Object Explorer select Reporting Services.

Enter your credentials to attach to your report server.

Right-click on your instance name and select Properties.

The Server Properties panel will appear; select Advanced on the left-hand pane.

From the advanced properties menu, you’ll notice an entire host of options you'll toggle. Below are three specific properties that we've modified for a couple of our customers’ implementations.


This setting is disabled by default, but many organizations like it better to enable this. The feature will provide every report server user with their own dedicated folder on the report server. This is almost like the My Workspace concept that users have within Power BI service. Enabling My Reports is a great way to encourage self-service BI.


This setting allows you to toggle what percentage days of report execution history are stored within the underlying ReportServer database. The default is 60 days. Increasing this value will collect more metadata, thus allowing you to research adoption over time. We mention how you'll monitor your report server.


This setting tells PBIRS what level of detail users can export data from a visual. In our experience, exporting underlying data can cause major performance bottlenecks if you’re not careful. This is very true if the underlying model is large (both in terms of knowledge and attributes/measures). For this reason, we encourage customers to disable this setting. Most of the time users will simply be happy to export the data that they see within the visual they're exporting from.

Why use Power BI Report Server

Using Power BI Report Server is that the next evolution for Business Intelligence tools and reporting, and it's definitely aimed toward the visualization market and competitors like Tableau and Qlik. Where Power BI Report Server excels is certainly associated with Microsoft's strong existing presence with SSRS, SSAS, and SSIS and therefore the big variety of knowledge sources available in Microsoft Power BI Implementation.

Additionally, the Power BI Report Server provides a rich, HTML5 reporting portal and a portal for all your reporting needs.

Furthermore, Power BI Report Server allows for branding the portal to match your organization’s branding, color, and logos.

Moreover, this version of the Reports Server allows report consumers to simply store Excel files which may successively be used as a knowledge source for other reports components.

Of course, the facility BI Reports element provides the rich interactive features that are being requested by modern report consumers. Finally, the facility BI Report Server gives you an avenue to use APIs as a conduit to utilize custom reporting solutions.

Who can use Power BI Report Server

Here is where Microsoft sets the parameters for having the ability to use Power BI Report Server. As a developer, you'll certainly use the developer edition to experiment and test the features. However, to use Power BI Report Server and every one its functionality in production, you want to have access to Power BI Premium. Power BI Premium includes many other benefits additionally to Power BI Report Server.

Furthermore, to really enjoy the rich features of Power BI Report Server, you are doing got to use what Microsoft calls a contemporary browser. This generally means you would like to be using the newest or near latest versions of the foremost common browsers. The good news is that it supports many of the browsers that were only marginally supported in past versions. The list includes:

IE 11
When can I use Power BI Report Server?
The simple answer is now. To get started, a developer edition is out there to be used during a testing environment and is that the perfect thanks to starting using Power BI Report Server. To know more about Microsoft Power BI Implementation-

Post a Comment