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

Harnessing the Power of Microsoft CoPilot in Power Automate Flows: A Comprehensive Tutorial

25 Mar 2024

In the ever-evolving landscape of technology and business automation, Microsoft has introduced a game-changer that is set to revolutionize how we […]
[read article]

Embracing AI: Transforming Jobs and Unlocking New Opportunities (Claude 3 Opus version)

18 Mar 2024

The rapid advancements in Artificial Intelligence (AI) have sparked both excitement and fear among workers worldwide. Many people are concerned that […]
[read article]

The Evolution of Work in the Age of AI: A New Era of Collaboration (ChatGPT 4 version)

18 Mar 2024

In the annals of human progress, pivotal inventions such as the steam engine, the tractor, and the internet have revolutionarily altered our way of […]
[read article]

AxioWorks Newsletter February 2024: Partnerships, Upcoming SQList Update, and Summit Invitation

27 Feb 2024

Hello Reader, This February has been pivotal for AxioWorks as we’ve focused on laying strong foundations for the year. Here are the key […]
[read article]

How AxioWorks SQList Aligns With the Priorities of Software Buying Decision Makers

26 Feb 2024

As outlined in the “2024 Global Software Buying Trends” report by Gartner Digital Markets, the criteria that predominantly influence […]
[read article]

Maximising Power BI Reporting from SharePoint: The Strategic Advantage of AxioWorks SQList over Native Connectors

15 Feb 2024

In today’s data-driven environment, making informed decisions rapidly can offer a significant competitive edge. This is where Power BI comes […]
[read article]

AxioWorks Newsletter January 2024: A Promising Start to the New Year!

29 Jan 2024

Hello Reader, We hope this newsletter finds you well and thriving. At AxioWorks, we are embracing the new year with great enthusiasm and are […]
[read article]

Exciting New Partnership and Innovative SharePoint Tools from AxioWorks and Lightning Tools

17 Jan 2024

AxioWorks is excited to announce a strategic partnership with Lightning Tools, a leader in creating innovative SharePoint components. This […]
[read article]

AxioWorks Newsletter November 2023: ESPC23, new partnership, and SQList update!

30 Nov 2023

Hello Reader, Welcome to this month’s edition of the AxioWorks newsletter! We’re thrilled to bring you updates on our recent […]
[read article]

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]

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

*