topic Re: PowerBi server and Sql server reporting services 2016 on same server in Report Server

PowerBi server and Sql server reporting services 2016 on same server

danm — Wed, 28 Jun 2017 19:22:25 GMT

Hi,

We have Sql server reporting services (2016) in use with couple reports. Can we install on same server PowerBi Server and use both for a while until migrate to Power BI server ?

Thank you,

Dan

Re: PowerBi server and Sql server reporting services 2016 on same server

Petebro — Wed, 28 Jun 2017 19:55:49 GMT

Power BI Report Server and SQL Server Reporting Services 2016 ARE able to be installed on the same server together. You can run them together while you migrate between them.

Also you are able to bring your catalog directly from SQL Server Reporting Services 2016 to Power BI Report Server. While the process is slightly different many of the steps are the same as the article found here: https://www.mssqltips.com/sqlservertip/2692/migrating-sql-reporting-services-to-a-new-server-by-moving-the-reporting-services-databases/

Re: PowerBi server and Sql server reporting services 2016 on same server

danm — Fri, 07 Jul 2017 13:34:00 GMT

Hi , I just try to install and I got the following message. Any suggestion ?

Microsoft power BI Report Server

(June 2017)

Setup blocked

The following issue blocked Setup

Installing this product when the January 2017 Reporting Services is currently installed is not supported. Uninstall the preview and the rerun this installer.

Thank you

Re: PowerBi server and Sql server reporting services 2016 on same server

mgmeyer — Fri, 07 Jul 2017 16:21:39 GMT

Based on the error message it looks like you have the first preview of Reporting Services 2017 that we released back in January. Unfortunately there were a lot of changes in both setup and the product since then and it requires that you uninstall and reinstall the latest build. If you have anything in your catalog make sure you backup your encryption keys before uninstall the product. If you have SQL Server Reporting Services 2016 installed you don't have to uninstall it, the error is specific to the preview release.

Re: PowerBi server and Sql server reporting services 2016 on same server

danm — Fri, 07 Jul 2017 16:53:36 GMT

And the version to uninstall is sql server reporting services 0.1.6214.16719 ? Thank you

Re: PowerBi server and Sql server reporting services 2016 on same server

mgmeyer — Fri, 07 Jul 2017 17:03:42 GMT

Yes, once you remove that it should unblock your PBIRS installation.

Re: PowerBi server and Sql server reporting services 2016 on same server

Anonymous — Fri, 22 Jun 2018 19:29:42 GMT

I tried installing Power BI report server on the same SSRS box (2016) and when I launch SSRS, IT works file. But for PBI Report server, I see this. What step am i missing?

sql01/ReportServerPBI - /

         Friday, June 22, 2018 8:56 AM       105184 Encounter Balance Due Insurance

Microsoft Power BI Report Server Version 15.0.2.402

Re: PowerBi server and Sql server reporting services 2016 on same server

kiwipeet — Fri, 05 Oct 2018 02:31:44 GMT

I found this thread a little confusing. (from the title). The difference between installing PBIRS to replace SSRS vs Installing them side by side.

I've finally suceeded in installing SSRS and PBIRS side by side on the same machine. If anyone esle is trying to do that you can read about it here: https://dba.stackexchange.com/questions/217741/ssrs-and-powerbi-report-server-on-same-server

Re: PowerBi server and Sql server reporting services 2016 on same server

Anonymous — Mon, 20 Jul 2020 11:30:33 GMT

If PBRS and SSRS are running in parallel on same server, is there any impct on performance of powwr BI reports?