Saturday, April 8, 2017

Can you save reports created in Power BI to a Report Server?

The answer is yes if you use the Technical Preview version of Power BI Desktop. You can save reports to your on premises SQL Server.

NOTE: If you already have configured a SQL Server 2016 Reporting Services server you will not be able to upload the reports from Power BI. You need to install the SQLServerReportingServices.exe mentioned below and configure a Standalone SQL Server Reporting Services which will provide a http:///ReportServer.

You can download this for both x32 and x64 versions. With this 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

If you do have Power BI for Desktop on your computer you still need the (January 2017) Technical Preview. This can sit alongside your present Power BI.

https://www.microsoft.com/en-us/download/details.aspx?id=54610

Preview version details below:
Version:            Date Published:

0.1                1/11/2017

File Name:                                                               File Size:

PBIDesktopRS.msi                                      102.2 MB

PBIDesktopRS_x64.msi                           118.3 MB

SQLServerReportingServices.exe    49.6 MB



System Requirements:
Supported Operating System

Windows 10 , Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

    You'll need
        .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
    Links:
        Get SQL Server 2016 Evaluation
        Try SQL Server vNext CTP1.1









No comments: