PBIX-in-SSRS

SSRS Hosting of On-premise Power BI Reports – Update Dec 2016

What is the current state of on-premise hosting of Power BI reports?

During the PASS Summit in October Microsoft announced that they would be releasing a technical preview of on-premise hosting of Power BI reports through SSRS. The preview, which can be accessed through the Azure marketplace, allowed anyone to spin up a virtual machine that included an installed and configured version of SSRS with sample data/files so customers could start exploring the solution immediately. It is worth mentioning that the current preview is very raw and rough; for one it can only be accessed through the Azure Marketplace and hence cannot currently be installed on your own environment and second it only supports live connections to Analysis Services cubes.

PBIX-in-SSRS

What’s to come with the next release?

The next technical preview is planned for January 2017 and unlike the current preview, you will be able to download and install it on your own virtual machine or server. Within this release, they plan to add support for mobile consumption, custom visuals and other data sources.

When will there be a production release?

Microsoft announced that it is planning to release the production ready version of SSRS on-premise hosting of Power BI files with the next release of SQL Server, explicitly adding that it will not be added into the SQL Server 2016 product. Interestingly, this implies that we could expect the next version of SQL Server mid-2017.

The following two tabs change content below.

Kale Temple

Kale Temple is a specialist in marketing and operational analytics. He has previously co-founded two start-ups, one of which he was the VP of Venture Operations. In this role he ran the core business, designed and implemented their BI strategy; using Tableau and Power BI, as well as used agile best practises to scale operations. He has presented several times throughout Australia at SQL Saturday on Power BI: beyond the basics with Iman Eftekhari. Kale holds both a Bachelor of Liberal Arts and Sciences (Economics) and a Masters of Economics (Economics & Econometrics) from the University of Sydney. He is currently a mentor at the University of Sydney Genesis Start-Up Program.