Sunday, April 9, 2017

Saving Power BI reports to SQL Server Report Server - Part 2

In an earlier post the method to save a report from Power BI to SQL Server Report Server was described. In order to do so you need to use the Technical Preview of Power BI Desktop.

In this post the installing of the Technical Preview will be described. The present Windows 10 Professional is a x64 bit machine and therefore we start with the .msi file shown here.

When you double click the above file you will be launching the wizard.

Click Next> to open the License Terms window.

Accept terms and click Next>. The default directory for the program is displayed. If needed change. Herein default is accepted.

Click Next>.  You are now ready to Install.

Click Install. It is installed. It may take 10 to 15 minutes.

Click Finish and if you have agreed to launch the program, the Power BI gets launched.The splash screen shows that this Power BI Desktop goes with SQL Server Reporting Services.

The program is now ready to create/save reports.

 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 in previous post and configure a Standalone SQL Server Reporting Services which will provide a http://<domain>/ReportServer.

PowerShell Pro Tools is a Visual Studio Community 2017 extension that you can try free

I see there is at least one extension, PowerShell Pro Tools that you can download. You can find it in the Visual Studio Community 2017...