Installing Power BI reports in SQL Server Reporting Services – On-premises

We tried it on an Azure VM, we’ve seen it at PASS Summit and in some private previews by the Reporting Services Team.

But now it is officially available to download for an on-premises installation as a 180 days preview.

What is really interesting, besides the fact that we get Power BI reports on-premises, is that there is a whole new installer to perform the installation.

This is how it looks like :

2017-01-17_21-23-07

After a few seconds downloading the software and a very short installation periodd, it is now installed!

This is so simple. Why didn’t you do that before Microsoft ?

Right after that you are presented with the well known Reporting Services Configuration Manager. From there it is a well known process to configure Reporting Services.

After that the process is exactly the same than when configuring SSRS for SQL Server 2016. You get the scale out option and of course the Power BI integration!!

Once it is installed you can navigate to the portal and create a new Power BI Report and get data from your favorite source.

2017-01-17_21-38-45

Adding a Power BI report opens a dialog just like when using Report Builder and I was expecting Power BI Desktop to start automatically – since it is installed on my PC – but it didn’t (double checked that Report builder did start automatically, and it did)

2017-01-17_21-53-02

Interestingly the Publish To Pyramid Analytics is now gone from the Publish menu in the January version of Power BI Desktop (Version: 2.42.4611.701 64-bit (Januar 2017))

2017-01-17_21-56-58

I couldn’t find any way to save to my Reporting Services instance, the Web Portal URL and the Web Service URL did not work so I uploaded the report manually.

If you try to upload anything else than a report containing data from a SSAS instance (tabular or multidimensional), you’ll get the following error:

2017-01-17_22-03-38

Using SSAS data on the other hand will give you the expected result !!

2017-01-17_22-20-18

Update

After installing the PowerBI Desktop for Reporting Services that was made available for download together with Reporting Services I am able to edit reports directly from the Reporting Services portal and to save Power BI reports straight into Reporting Services

2017-01-18_07-03-30

Saving in Reporting Services now work directly from Power BI as shown below:
2017-01-18_07-11-52

Conclusion :

  • We are getting this long awaited on-premises Power BI Desktop
  • The installation process is really simple, it is a pleasure.
  • No publishing to Pyramid
  • I was not able to save the Power BI desktop file directly to my reporting services instance
  • For now I can only connect to SSAS on-premises, but live query seems supported, although I haven’t tried
  • I LOVE IT ALREADY !!

In a next post, I will try to pass Reporting Services parameters to the Power BI report and see if that works…

Happy Power BI’ing

Advertisements

3 comments

  1. Did you happen to install the PBIDesktopRS.msi as well? You will need that edition of desktop to save/open from the report server.

    1. Hi Jon-H,
      Thanks for pointing that out for me.
      Cheers
      Régis

  2. […] but with the January 2017 Preview there is an installation for SSRS vNext available. Regis (blog) already wrote about his first experiences with the installation. I would only like to add some […]

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

%d bloggers like this: