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

Download and Install Report Builder for SQL Server 2016

Report Builder is a highly productive, stand-alone tool for authoring reports and deploying them on configured Microsoft Reporting services report servers. It can use data from different kinds of data sources to produce  a variety of reports, from hard copies to web based reporting.

Report Builder 3 Details:
--------------
Version:
14.0.344.82
File Name:
ReportBuilder3.msi
Date Published:
3/9/2017
File Size:
22.6 MB
-----------------

You need Microsoft .NET Framework 4.5. The memory and CPU requirements are average.

This is supported on  the following OSs:
Windows 10 , Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

download from here:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=53613

Please review the earlier versions of Report builder in two of my published books here:


The second book Learning SQL Server 2008 Reporting Services is ideal for beginners who want to spin-out reports from a variety of data sources and deploy them to report servers. The book is replete with step-by-step, hands-on exercises where the users can hone their skills.

 

The fifth book Learning SQL Server Reporting Services 2012 is a revised edition and a deals with both Native and SharePoint Integrated modes of Report Servers. This covers every aspect of the first edition(second book) with lots of added material to include development in the intervening years.

  As the author of these Microsoft Business Intelligence related books I have great confidence in their usefulness. I would love to hear from you. Email me at: hodentek@live.com.

Installing Report Builder

You will have downloaded the ReportBuilder.msi file published on 3/9/3017. Note that there are other Report Builder.msi related to other versions (for example ReportBuilder.msi for SQL Server 2014 etc).

The installation is driven by a wizard and it installs without any problem. You need not indicate a Reporting Services Report Server during installation.

Here are screen shots of the installation:

Welcome Screen

License agreement window. Click I Accept...

 It will be installed on the local hard drive. Note that this product may also work with SQL Server vNext CTP1.3.

SQL Server 2016 reporting services has two modes and you need not have these installed and configured. You may keep this empty. Click Next.

Click Next and you are ready to install.

 Click Install. Begins installing with a progress screen.

 It is done installing.

 You should see these in All Programs on Windows 10.

Double click and you are ready to Author a report. If you want to put it out on the Report Server, you need a Report Server.

You are ready to go!

What do you need to author a Power View Report?

This is the first question that you ask yourselves.

As Power View report is based on data it finds on a tabular data model, you need SQL Server Analysis Services(SSAS) server, which can host a tabular model. This means that you must have
configured the SQL Server Analysis Server to support tabular model. You create
the tabular model using SSDT, which installs when you install SQL Server 2012.

However with SQL Server 2014 which went RTM recently you can create Power View Reports as well as DAX queries using the Multi- dimensional models.

Installing SSAS to support tabular model was covered in Chapter 1, Overview and
Installation – SQL Server Reporting Services 2012 of my book Learning SQL Server Reporting Services 2012.

Also, as the PowerView is launched from SharePoint Server 2010, you want
the SQL Server Reporting Services 2012 configured to operate in integrated mode
with SharePoint Services. Installing Reporting Services 2012 in SharePoint Integrated mode was
described in Chapter 1 , Overview and Installation – SQL Server Reporting Services 2012 of my book..
The Power View reports in the above chapter are based on these premises. Power Views
are only possible for enterprise-grade servers for both SharePoint Server 2010 and
SQL Server 2012.
The environment for developing Power View described in this book is based on
the following:
•  Possibility of installingSharePoint 2010 Server on Windows 7 (x64) computer
•  Installing SQL Server 2012 Reporting Services in SharePoint Integrated mode
•  Configuring SQL Server 2012 Analysis Services to support tabular
data model
•  Availability of a Silverlight-enabled browser