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 :
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.
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)
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))
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:
Using SSAS data on the other hand will give you the expected result !!
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
- 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