HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SSRS and PowerBI Report Server on same server

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
ssrssameserverandreportpowerbi

Problem

I've just installed the August 2018 release of PowerBI Report Server onto the same Win 2012 server with SSRS 2016. I can get it running but it clashes with SSRS with URL reservations.

I've configured them to use different Virtual directories and ports but SSRS keeps breaking.

  • SSRS: http://ServerName:80/Reports



  • PBIRS: http://ServerName:8080/PBIReports



What have I missed?

Edit: I have SSRS 2017 and PBIRS working at the same time on my laptop. Both on Port 80 but with different virtual directories.

Solution

I now have this working on my Win-2012 server with PBIRS (August 2018) and SSRS 2016.

First they need to have thier own ReportServer Databases. I used:

  • SSRS: ReportServer



  • PBIRS: PBIReportServer



The Webservice URL's use the same port number but different Virtual directories.

  • SSRS: http://ServerName:80/ReportServer



  • PBIRS: http://ServerName:80/PBIReportServer



And the Webportal again uses the same port number, but different URLS.

  • SSRS: http://ServerName:80/Reports



  • PBIRS: http://ServerName:80/PBIReports



And so far it seems to be behaving. I've restarted the server and both services started automatically and appear to be working.

Context

StackExchange Database Administrators Q#217741, answer score: 5

Revisions (0)

No revisions yet.