560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
What Power BI report server is, and how to create reports through it
Part one of a five-part series of blogs
Puzzled as to why there are two near-identical versions of Power BI Desktop? Wondering if web portal is anything like Power BI report server? Confused as to what a paginated report is? This blog answers all these questions, and more!
In this series of blogs, I'm going to try to explain what Power BI Report Server is, exactly how a paginated report differs from a normal Power BI report, and whether you should be considering installing and using Power BI Report Server.
Power BI report server, after uploading one Power BI, one mobile and one paginated report.
This blog supersedes (and expands on) my colleague Andy Gould's blog on the same subject, first published in March 2019.
Power BI report server is the same as the old Reporting Services web server, but with two additional features - it can accommodate Power BI and mobile reports:
You can publish three types of reports to Power BI report server.Â
Using Power BI report server gives three big advantages:
|Convenience||As you'll see throughout this blog, it's very easy to create reports from Power BI report server and then publish them.|
|A one-stop shop||Having your paginated and Power BI reports accessible from a single website is convenient.|
|Local storage||Since Power BI report server sits within a SQL Server database on your server, you don't need to worry about saving your organisation's confidential data in the cloud.|
Against this, it has three disadvantages:
|Cost||As you can see from the licensing cost notes further down this page, Power BI report server is not cheap to run.|
|Modernity||The version of Power BI used by Power BI report server is usually a few months behind the latest Power BI Desktop update.|
|Future-proofing||Microsoft are quite clearly desperate for any organisation running Power BI report server to upgrade to holding their reports on Azure in the cloud. There's always the tiny worry of how much longer they will let companies store their own data onsite.|
Here are examples of the three types of reports that you can create in Power BI report server. First, Power BI reports:
In a Power BI report you have a number of visuals (this report has one slicer and one column chart). When you click on a value on one visual, the other visuals on the page usually update to show that value's data (so for example choosing a director above such as Chris Columbus would show that director's films in the chart on the right).
The second type of report is a paginated report:
In a paginated report you typically see grouped data (here we're listing the films made by director). A paginated report (as the name would suggest) usually consists of a number of pages, with titles repeating at the top of each. Paginated reports often contain parameters at the top, and are used for printing.
The third type of report is a mobile report:
A mobile report typically consists of a grid of visuals for viewing on a tablet or mobile. The size of the visuals is responsive, adjusting to different screen sizes.
Microsoft software licensing is complicated and subject to frequent change, but here's a summary of my understanding of how it works with relation to Power BI report server at the time of writing. There are three ways in which you can install and use Power BI report server:
Furthermore, anyone wanting to publish Power BI reports to your report server will (as I understand it) need a Power BI Pro (or Power BI Premium) licence.
The rest of this blog is divided as follows:
|Setting up PBRS||Installing and configuring Power BI report server|
|Paginated reports||How to create paginated reports for viewing within Power BI report server|
|Power BI reports||How to create Power BI reports for viewing within Power BI report server|
|Moible reports||How to create mobile publisher reports for viewing within Power BI report server|
|Parts of this blog|
25 Aytoun Street