BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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!
- Power BI Report Server
- Installing and Setting Up Power BI Report Server
- Creating paginated reports
- Publishing Power BI reports to Power BI Report Server (this blog)
- Creating mobile reports for Power BI Report Server
Posted by Andy Brown on 23 December 2020
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Publishing Power BI reports to Power BI Report Server
To create a report for publication on Power BI Report Server, you must use Power BI for Report Server!
Power BI for Report Server is pretty much identical to Power BI Desktop, and you can run both applications side-by-side on your computer. The main difference is that Power BI for Report Server is more stable: it doesn't include any preview features, and updates are only released about once a quarter (as opposed to once a month for standard Power BI Desktop).
Follow the steps below to create a Power BI report for viewing in Power BI Report Server.
Starting to add a report
You start to add a Power BI report in the same way as adding a paginated report:

Choose this option to create a new Power BI report.
Downloading and installing Power BI for Report Server
I've got Power BI on my laptop, but it's not the version for Report Server, so I've chosen to download the Report Server version:

Click on the button to download Power BI for Report Server.
You'll be taken to a website, where you can download the right version of Power BI Server:

Click to download the software (at the time of writing this is the May 2020 edition, which is 7 months behind the standard version of Power BI Desktop).
Choose whether you have a 32-bit or 64-bit computer:

I've got a 64-bit laptop, as (almost certainly) will you - why can't it detect this though?
When the installation program has downloaded, choose to run it:

What this looks like in Edge, for example.
After a couple of stages of the wizard, you'll be asked to choose an installation folder:

I've gone for the default, yet again!
You can now start the installation:

Go for it!
You'll probably then need to confirm you want to proceed, after which time you'll see a status message:

Things are going swimmingly.
Finally, you'll see a completion message:

You can now finish the installation.
Creating a Power BI report
When you create a new report again following the steps at the top of this page, you'll now be taken into Power BI for Report Server:

A trip back in time to the May 2020 version (at least at the time of writing).
Compare the two icons!

The one on the left is Power BI Desktop; the one on the right Power BI for Report Server.
You can then create your Power BI report:

This report was created using exactly the same data source as the paginated report for the previous page of this blog.
Saving your report to Power BI Report Server
When you've created your report, you can save it directly to Power BI Report Server:

Choose Save as, and choose to save your report to Power BI Report Server.
If this is the first time you've done this, you'll be asked to type in the location of your report server:

Enter the location of your report server and select OK.
You can then give your report a name:

Here I've called this report Films for directors.
Success!

You could if you like click on the link to go to your report server.
Viewing your report in report server
When you press F5 to refresh Power BI Report Server, you'll see your new report:

You can now click on your new Power BI report to view it.
When you view your report, you'll see the interface is a bit different to (and simpler than) Power BI Service:

Viewing a report through Power BI Report Server
I've been astonished throughout creating this blog by how simple the process is, and how clear it is what's going on behind the scenes. I'm now a big fan of Power BI Report Server!
- Power BI Report Server
- Installing and Setting Up Power BI Report Server
- Creating paginated reports
- Publishing Power BI reports to Power BI Report Server (this blog)
- Creating mobile reports for Power BI Report Server