Saturday, April 8, 2017

Saving Power BI reports to SQL Server Report Server

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://<domain>/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.
=====================
Technical Preview of Power Bi for Desktop download link
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









1 comment:

What is SQLOISIM? What is it used for in SQL Server?

SQLIOSIM is a tool for simulating SQL Server IO. SQLIOSIM performs reliability and integrity tests on the disk systems that SQL Server uti...