Thursday, April 27, 2017

This is how you save a report authored in Power BI to a Report Server - Final

I apologize to the readers of my post,Can you save reports created in Power BI to a Report Server?  for having given the wrong impression. The reports you create cannot be saved to any report server but the stand-alone report server created using the same .msi file downloaded from the same location where you downloaded Power BI Desktop Technical Preview.

I am only partly to blame for this and I apologize. Let me correctly present what kinds of reports can be saved to what kind of report server. The other reason for the problem was created by the Power BI itself for giving the wrong guidance for the users while saving the report to the report server. It must be changed.


  • The only kind of reports that can be saved to Report Server (strictly speaking, you are only saving it to the Web Portal URL) are the ones created with data from the Analysis Services server.
  • In order to save you need to configure a stand-alone Report Server whose database is stored not on a SQL Server 2016 but an earlier version. In my case I use the SQL Server 2012. The .msi file for this server is on the same download site as the Power BI Technical Preview.


After you fulfill the above conditions then only you can host the report.


I was able to get the correct server by an answer to my question on StackOverflow.com.


http://stackoverflow.com/questions/43402339/invalid-url-error-while-saving-power-bi-report-to-sql-server-reporting-services


Sunday, April 09, 2017

From PowerBi to Report Server, the easy way

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









Wednesday, April 05, 2017

How do the File Share account settings are used in SQL Server Reporting Services 2016?

This is feature is applicable only for Native Mode.

In order to specify a single file share account ( a new feature of SQL Server 2016) you must get to the Subscription Settings page of the SQL server 2016 Reporting Services Configuration Manager shown here.


The file share account that you set up here allows you to set a single set of credentials in multiple subscriptions that deliver reports to a file share.

When you want to change credentials you just change the credentials of the file share and you need not change the credentials of every subscription in the shared folder. In the subscriptions in the file share each subscription will specify; Use file share account.

However you may also configure individual subscriptions with specific credentials as well or, have some on file share and some with individual specific credentials.
DMCA.com Protection Status