Yesterday, January 17, 2017, Microsoft released the Power BI reports in SQL Server Reporting Services (SSRS) technical preview. You can read all about it here. I downloaded the technical preview and installed it on my system and deployed a Power BI Visual to my SSRS web site. Here are the steps to get it installed on your system.
· The Technical Preview has the following system requirements:
- 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
· I first installed the SQLServerReportingServices.exe on my system and accepted the licensing terms and agreement and then selected the “Install” button.
· After the installation completed I needed to configure the technical preview of SSRS by selecting the “Configure Report Server” button.
· I provided my SQL Server name to Connect the Reporting Services Configuration Manager.
**NOTE – While the configuration manager let, me configure the SSRS technical preview web site with my original VM’s computer name of ‘BARRYCROWEL38F0’ I could not publish by Power BI report with that computer name. I shortened the name to 7 characters and removed the numbers from the name to get the Power BI Designer Technical Preview to function with the SSRS web site.
· Design a Power BI visual with the Power BI Designer Technical Preview. In my visual, I connected to an SQL Server Analysis Services (SSAS) database. To publish you report to SSRS, select the ‘Save As’ menu option.
· Following the screen prompts and supply the Reporting Server.
· Then enter the report name.
The final product is a Power BI visual with slicer functionality in an on premise SSRS web site.
**NOTE – the current SSRS technical preview does not work with custom visuals or R visuals.
I’m loving the first on premise technical preview and can’t wait for what next.