Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
This article forms part of the Power BI implementation planning series of articles. This series focuses primarily on the Power BI experience within Microsoft Fabric. For an introduction to the series, see Power BI implementation planning.
The on-premises reporting scenario is one of several hybrid and custom scenarios for deploying Power BI solutions without using the Power BI service.
This scenario involves using Power BI Report Server, which is an on-premises portal for publishing, sharing, and consuming business intelligence content within the organizational network. It's useful when the organization needs an alternative to the cloud-based Power BI service for deploying some (or all) BI content. For example, a fully customer-managed platform could be necessary for regulatory, legal, or intellectual property reasons.
The following diagram depicts a high-level overview of the most common user actions and Power BI components to support on-premises reporting. The focus is on using Power BI Report Server, which runs on a Windows server within the organizational network.
Tip
We encourage you to download the scenario diagram if you'd like to embed it in your presentation, documentation, or blog post—or print it out as a wall poster. Because it's a Scalable Vector Graphics (SVG) image, you can scale it up or down without any loss of quality.
The scenario diagram depicts the following user actions, tools, and features:
Item | Description |
---|---|
A Power BI content creator builds a BI solution. | |
Power BI Desktop for Report Server connects to data from one or more data sources. Queries and data mashups, which combine multiple sources, are developed in the Power Query Editor. | |
Data model development and report creation are done in Power BI Desktop for Report Server. It generates a specific type of Power BI Desktop file (.pbix) that can be published to Power BI Report Server. | |
The report creator can also build paginated reports using Power BI Report Builder. This tool generates a Report Definition Language file (.rdl) that can be published to Power BI Report Server. | |
The report creator can also develop reports using Excel. The Excel workbook file (.xlsx) can be published to Power BI Report Server. | |
When ready, the content creator publishes their file to Power BI Report Server. | |
Content is published to a folder in Power BI Report Server. | |
Report consumers view reports published to Power BI Report Server. | |
Report consumers can also view reports using Power BI mobile apps. | |
Server administrators manage the Windows server infrastructure. | |
Database administrators manage Power BI Report Server, including the report server databases, and SQL Server Agent. | |
SQL Server Agent jobs periodically refresh import semantic models. | |
Administrators oversee and monitor activity in Power BI Report Server. |
The following are some key points to emphasize about the on-premises reporting scenario.
Content creators use a specific tool named Power BI Desktop for Report Server. This version of Power BI Desktop is updated three times per year and is compatible with the Power BI Report Server release cycle.
Note
For report creators who create content for both the Power BI service and Power BI Report Server, the two versions of Power BI Desktop can be installed side by side.
The report consumer experience for Power BI Report Server is very different from the Power BI service. The Power BI Report Server is a web portal for viewing, storing, and managing content. Content files (.pbix, .rdl, or .xlsx) are published to a folder hierarchy. For more information, see Manage content in the web portal.
Power BI Report Server is a distinct product from SQL Server Reporting Services (SSRS). It's licensed and installed separately. Power BI Report Server is considered a superset of SSRS because it comprises additional capabilities beyond SSRS.
Important
Although Power BI Report Server and the Power BI service are supported by the same engineering team at Microsoft, there are substantial functionality differences between the two products. Power BI Report Server is a basic reporting portal for on-premises reporting. For this reason there are many feature differences between it and the Power BI service. The feature set of Power BI Report Server is intentionally simple, and parity should not be expected. Before installing Power BI Report Server, verify that critical features you intend to use are supported.
SQL Server hosts the Report Server databases. Most commonly, a SQL Server Database Engine instance is installed on a Windows server in an on-premises data center. It can also be installed on a virtual machine in Azure (hosted cloud) or hosted by Azure SQL Managed Instance (not depicted in the scenario diagram). The database infrastructure is managed by a database administrator.
Additional configurations must be done to enable remote mobile access to Power BI Report Server. For more information, see Configure Power BI mobile app access to Report Server remotely.
There are two ways to license Power BI Report Server: Power BI Premium and SQL Server Enterprise Edition with Software Assurance.
Important
At times this article refers to Power BI Premium or its capacity subscriptions (P SKUs). Be aware that Microsoft is currently consolidating purchase options and retiring the Power BI Premium per capacity SKUs. New and existing customers should consider purchasing Fabric capacity subscriptions (F SKUs) instead.
For more information, see Important update coming to Power BI Premium licensing and Power BI Premium FAQ.
With the purchase of Power BI Premium capacity, Power BI Report Server can be installed on an on-premises server, provided it has the same number of cores as the capacity node's v-cores. This way, it's possible to adopt a hybrid approach supporting publication of content to the Power BI service (cloud) and to Power BI Report Server (on-premises or hosted cloud in Azure).
Note
When licensing Power BI Report Server as part of the Premium capacity feature set, it's only available with the P SKUs. The other capacity-based SKUs (EM and A SKUs) do not offer this benefit, nor does Power BI Premium Per User (PPU).
For other useful scenarios to help you with Power BI implementation decisions, see the Power BI usage scenarios article.
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Publish and access reports in Power BI service – Online workshop - Training
Learn how to use Power BI to create a mobile view, publish a report, build a dashboard, and use storytelling with Power BI within PowerPoint.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Documentation
What is Power BI Report Server? - Power BI
Get an overview of Power BI Report Server to understand how it fits in with SQL Server Reporting Services (SSRS) and the rest of Power BI.
Compare Power BI Report Server and the Power BI service - Power BI
This article compares the features of Power BI Report Server and the Power BI service.
Capacity planning guidance for Power BI Report Server - Power BI
This paper offers guidance on capacity planning for Power BI Report Server by sharing results of load test executions of various workloads.
Hardware and software requirements for installing Power BI Report Server - Power BI
This article lays out the minimum hardware and software requirements to install and run Power BI Report Server.