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!

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