Power BI reports in SQL Server Reporting Services: January 2017 Technical Preview now available

NOTE: This blog post describes an early Technical Preview of Power BI reports running on SQL Server Reporting Services’s on-premises report server platform. In June 2017, we brought this technology to market as Power BI Report Server. For more info, check out A closer look at Power BI Report Server.

Happy new year! In our previous post before the holidays, we mentioned we were working toward releasing the next Technical Preview of Power BI reports in SQL Server Reporting Services in January. Today, we’re pleased to make the January 2017 Technical Preview available for download.


Try it on your on-premises server

We released the October 2016 Technical Preview as a pre-configured Virtual Machine in the Azure Marketplace. We received a lot of enthusiastic feedback that this VM with everything you need preloaded – Power BI Desktop, Reporting Services, Analysis Services, and even some sample data and reports – made it really quick and easy to try this exciting new feature.

With the January 2017 Technical Preview, in addition to trying the VM in Azure, you can now download the software and install it on your own on-premises VM or server. In the latter case, you’ll need

  • Your own VM or server (not one in production use)
  • Windows Server 2012 or later (or Windows 8 or later)
  • .NET Framework 4.5.2 or later
  • SQL Server Database Engine (2008 or later), to store the report server database
  • SQL Server Analysis Services (2012 SP1 CU4 or later), to store your data models

Need a copy of SQL Server to try? Get SQL Server 2016 Evaluation or try SQL Server vNext CTP1.1.

Download and install in minutes

We’ve learned a lot about how customers install and upgrade Reporting Services and we’re incorporating that feedback into a standalone setup for the January 2017 Technical Preview. This standalone installer offers a lightweight download and a simplified setup process. It’s a work in progress and you’ll notice it evolve in an upcoming preview, but already, you can install the Technical Preview in just a few minutes. Plus, installing the Technical Preview won’t affect any Database Engine instances or other SQL Server features.

In tomorrow’s post, Chris Finlan will guide you through the setup process step-by-step.

Create reports with Power BI Desktop

Along with the new setup, you’ll find a Technical Preview version of Power BI Desktop for download (in 32-bit and 64-bit flavors). With it, you can

  • Connect “live” to Analysis Services models – both Tabular and Multidimensional (cubes)
  • Visually explore data and create an interactive report
  • Save that report to your report server running the Technical Preview
  • View and interact with the report in your web browser

You do need to use this Technical Preview version of Power BI Desktop. If you already have another version of Power BI Desktop installed, you can install this one side-by-side.

More to come

We’re hard at work on enhancing the setup experience and Power BI report functionality for upcoming releases. In the meantime, we hope you enjoy trying the January 2017 Technical Preview and we’re eager to hear your feedback.

Try it now and send us your feedback