Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Power BI Report Server : An On-Premises Report hosting Suite

by Danish Ali Detho | O365 & Power Platform Solution Architect

Power BI has become the most widely used tool for reporting due its user-friendly interface which allows business users to generate sleek and customizable reports and interact quickly and easily with their data using simple drag-and-drop features and a plethora of customizable visualizations.  Power BI Service further extended the capabilities by providing a robust report hosting cloud-based SaaS platform through which reports can be easily shared with colleagues for collaboration and made more accessible. However, if your organization has an on-premises setup and doesn’t want to set up a Gateway to expose the reports to the cloud then Power BI Service cant be used for hosting reports and an OnPremises hosting server would be required. In order to provide similar functionality to the on-premises users, Microsoft has introduced Power BI Report Server which uses SQL Server Reporting Services technology for hosting reports On-Premises. In this blog, we will take a deeper look at the Power BI report server, its features, and functionality, and how it is compared with Power Bi Service.

Power BI: A reporting tool like no other

Microsoft Power BI is a desktop-based reporting tool that enables you to collect, filter, combine, analyze and visualize and finally publish your data in form of a report or a collection of reports called Dashboard. Power BI provides a simple and user-friendly interface that can be used by business and power-users easily. Also, it allows for collecting data from a wide range of data sources. If you’re a business or power user who wants to work robustly on the data of your organization, then you will be using Power BI Desktop which is free to download.

Power BI Report Server: An On-premises Power BI Service alternative

Power BI Report Server is an on-premises report distribution technology offered by Microsoft Power BI Deployment Suit that is primarily used for hosting and sharing Power BI reports. Since it should be hosted on the machine in the company’s domain, it’s not an online service and therefore allows organizations to host and share reports OnPremises. It comes with a web portal which is an entry point to access Power BI reports and provides additional tools to create and host Power BI reports paginated reports, mobile reports, and KPIs. It consists of a web portal that provides features to view Power BI reports, paginated reports, Excel files, and KPIs, and navigate through the elements in your report server instance. You can also use the web portal to administer a single report server instance.

How it works

Note: Do check out the  Hardware and Software Requirements for installing Power BI Report Server.

  • Install and configure the Report Server by following the installation guide.
  • Develop Power BI reports using Power BI Desktop.
  • Once the report is ready, Publish it to the report server.
  • Once the report is available in Report Server, share it with other colleagues.

Power BI Report Server vs Power BI Service

Capability Report Server Power BI Service
Hosting Technology On-Premises Cloud-based (SAAS)
Data sources Cloud and/or on-premises Cloud and/or on-premises
Sharing Reports Yes Yes
Access reports via Power BI Mobile App Yes Yes
Setup Row Level Security (RLS) Yes Yes
Creating Dashboards No Yes
Setup Data Alerts No Yes
Usage of R and Python Engine No Yes
Connectivity to Azure Machine Learning No Yes

Main Features

  • A centralized report server for hosting Power BI reports or Paginated reports (.rdl) on-premises so that they can be shared with other users for collaboration.
  • Allow Users to access reports on a web portal and set up access permissions.
  • Additional visualizations are available for reports hosted on the report server.
  • Allows users to access reports on their cell phones using Power BI Mobile App.

Licensing Requirements

Power BI Report Server is available through two different licenses:

  1. Power BI Premium
  2. SQL Server Enterprise Edition with Software Assurance.

Note: If you publish Power BI reports to Power BI Report Server, you also need a Power BI Pro license. You don’t need a Power BI Pro license to view and interact with Power BI reports on Power BI Report Server.

Conclusion

Power BI Report Server is an on-premises reporting server based on SQL Server Reporting Services technology which allows users to host their interactive reports fully on-premises without needing a Power BI website. You will not need a gateway, and all types of connections (Scheduled Refresh, DirectQuery, and Live Connection) are supported (Except the composite model). It does lack a lot of features if you compare it with Power BI Service but it does offer enough capabilities to make it desirable for organizations who want to keep their Power BI reports on-premises but are still able to share them with users.

 

Latest articles

Why Support Legacy SharePoint Versions Like SharePoint 2010?

16 Nov 2023

In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why […]
[read article]

Why Companies are choosing SQList over Power Automate

30 Oct 2023

In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as […]
[read article]

AxioWorks Newsletter October 2023: An exhilarating month.

28 Oct 2023

Hello Reader, As we step into the season of autumn, we are thrilled to share with you the latest developments and opportunities unfolding at […]
[read article]

Why Choose SQList for SharePoint Data Extraction Over DIY Solutions

16 Oct 2023

In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can […]
[read article]

AxioWorks Newsletter September 2023: An exhilarating month.

30 Sep 2023

Hello Reader, September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
[read article]

The Collaborative Pathway: Bridging Minds in the AI Ecosystem

19 Sep 2023

In recent days, I found myself immersed in an enlightening conversation with a friend, a fellow entrepreneur steering his ship in the vast sea of […]
[read article]

AxioWorks Newsletter August 2023: A month of milestones and innovation.

28 Aug 2023

Hello Reader, September seems to be a month of unexpected milestones and continued innovations at AxioWorks. As the summer wanes and the autumn […]
[read article]

Use Graph API in Power Automate to read large Excel files from SharePoint

28 Aug 2023

Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business […]
[read article]

From Punch Cards to Python: Still Hitting the Keys in my 50s

16 Aug 2023

I spent the entire weekend writing code, not because of deadlines to meet or million-pound dreams, but for the kick that I still get from doing it. […]
[read article]

AxioWorks Newsletter July 2023: Unveiling AxioWorks’s latest successes and exciting innovations

27 Jul 2023

Hello Reader, We hope this monthly update finds you in good spirits. As always, we are eager to share the latest developments and exciting ventures […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter

*