Power BI Report Server – Preview version

Preview version of Power BI Report Server is available. It’s called May 2017 Preview and is available together with dedicated Power BI Desktop application.

Let’s take a look how to install and generally how it works!

What is it? It is a combination of Power BI Desktop features with SQL Server Reporting Services and it works on-premise.

Let’s take a look at the Power BI on-prem vs other products.

Blog_PowerBIReportServerPreview_23

Acquiring Power BI Report Server we can use Power BI reports, paginated reports (rdls) and mobile reports (based on Datazen) on-premises.

It is based on SQL Server Reporting Services but is separated from SQL Server setup and release cycle. It will be updated multiple times per year!

You can also migrate reports from SSRS 2008 or later to this version.

Prerequisites

Power BI Report Server requires:

  • .NET Framework 4.6
  • Operating system – from Windows Server 2012-2016, or Windows 8.1-Windows 10
  • x64 processor
  • SQL Server 2008-2016. It is required after installation and it is not required to collocate it with Power BI Reports Server.

More at Hardware and software requirements for installing Power BI Report Server

 Installation

First you need to download Power BI Report Server from Microsoft Download Center.

Run the installer file and choose Install Power BI Report Server.

Blog_PowerBIReportServerPreview_1

In the screens you must accept license agreements, choose install folder and edition type (evaluation, developer or provide key).

Configuration

After installation complete we must configure Report Server.

Blog_PowerBIReportServerPreview_3

This is the same configuration steps as in SQL Reporting Services. We need to configure accounts, database and URLs.

Next step is to verify our new Power BI Report Server. Simple go your Web Portal URL.

Blog_PowerBIReportServerPreview_4

Install Power BI Desktop

We need to install special version of Power BI Desktop which works with Power BI Report Server. Installer is available on Microsoft Download Center.

This version can coexist with normal version of Power BI Desktop (you can have both installed on computer).

Create report

Now we can start creating our first Power BI on-prem report.

This preview version (May 2017) supports only Analysis Services as data source so let’s create one. Simply choose Analysis Services and enter server name.

Blog_PowerBIReportServerPreview_5

Now choose model.

Blog_PowerBIReportServerPreview_6

And build some Dashboard.

Blog_PowerBIReportServerPreview_7

Now we can save it directly to Power BI Report Server. Simply choose Save As and select Power BI Report Server.

Blog_PowerBIReportServerPreview_8

Enter your report server URL.

Blog_PowerBIReportServerPreview_9

Now we can go to the Web Portal and see how it works.

Blog_PowerBIReportServerPreview_11

The same Dashboard as created in Power BI Desktop. Rendered directly on-premises.

Conlcusions

As you can see installation process is simple and fast. If you are familiar with SQL Server Reporting Services it takes you only a few minutes.

This version allows only Analysis Services as data source only but for testing it is really enough. More data sources will come in next versions.

There are some bugs and glitches but this is a preview and I hope that final version will be polished.

It works fast, experience is almost the same as in classic Power BI and it works on-premises. Now we only need to wait for final version which is expected this month!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s