Category Archives: Enterprise IT

Power BI Report Server - On-premises hosting of Power BI Dashboards

Power BI Report Server – Resources

Power BI Report Server (PBIRS) – Notes and Resources

This blog article will serve as a running notebook for information and findings related to Power BI Report Server, also known as PBIRS

What is Power BI Report Server (PBIRS)?

PBIRS is a recently released Microsoft server product that allows a company to host on-premises Power BI dashboards (as well as traditional SSRS reports).

It’s very similar to SSRS.

Use Cases – Why Would You Use This?

This on prem server would be an attractive option for companies which:

  • Can’t utilize cloud hosted Power BI – Perhaps because of client or government related cloud restrictions in regards to handling of confidential data

How Is PBIRS Licensed?

There are two ways to acquire the licensing:

  • SQL Server Enterprise Edition with Software Assurance – If you own these licenses, you are entitled to use PBIRS
  • Power BI Premium service – If you are a customer of Power BI Premium, you can run an equivalent number of cores onsite for your PBIRS implementation. For example, as a P1 customer, you are entitled to 8 v-cores – you can then run an equivalent number of cores utilizing PBIRS on-premises.

What Are The Limitations of PBIRS?

  • Current GA release (June 2017) only supports Analysis Services as a Data Source (SQL Server support coming with next release – date TBD)
  • Current GA release requires a special version of Power BI Desktop, which has the proper dialogs for opening from and saving to the PBIRS instance. This is known as “Power BI Desktop optimized for Power BI Report Server”
  • Security is enforced via Active Directory integration, or custom security form. Custom security form is NOT supported by the Power BI Desktop client, which means if you need to create your own security provider, a manual download, edit, and upload cycle will have to be used to edit dashboards hosted on PBIRS

Power BI Report Server - File Open Selection

Power BI Report Server - Save As menu

Power BI Report Server Download Links

How To Install

  • Install Power BI Report Server (PowerBIReportServer.exe)
  • Configure your report server using Report Server Configuration Manager
  • Install Power BI Desktop (PBIDesktopRS_x64.msi)

Power BI Report Server Documentation Links

Power BI Report Server August 2017 Preview

The latest, non-GA release will allow the use of all data sources. It can also be integrated with Office Online Server, to allow editing of Excel sheets. However, it does have these limitations:

  • Scheduled data refresh is currently not available for reports using imported data.
  • Direct Query data connections are not currently supported.
  • Scale-out environments for Power BI Report Server are not officially supported using the preview release.
  • Reports must be smaller than 50 MB in size.

Official release date is “later in 2017”.