topic Re: SSRS on PBIRS in Report Server

SSRS on PBIRS

cnschulz — Tue, 14 Jan 2020 02:56:45 GMT

Gday,

We are moving many SSRS reports from 2008 (!!) to 2016 as well as building a new PBIRS server. Is it best proctice to have SSRS running as a seperate install on the server or simply just run PBIRS and use that to host the SSRS reports? Apart from having alternate URLs I cant see any reason not to have a single software solution (PBIRS only)

Comments?

Re: SSRS on PBIRS

d_gosbell — Tue, 14 Jan 2020 05:08:18 GMT

It's best to just have PBIRS. I think you'll actually find that it's not supported to run both SSRS and PBIRS on the same machine as they tend to interfere with each other. And PBIRS is a superset of SSRS anyway.

Re: SSRS on PBIRS

cnschulz — Tue, 14 Jan 2020 21:59:12 GMT

d_gosbellThank you. This is my preferred option. Only downside I can see is a single URL for access. Currently our two systems have /reports and /powerbireports ass the access URLs and I'd like to replicate that on the new (single instance) box.

Thanks for your help

Re: SSRS on PBIRS

d_gosbell — Tue, 14 Jan 2020 23:37:03 GMT

cnschulz wrote:

Only downside I can see is a single URL for access. Currently our two systems have /reports and /powerbireports ass the access URLs and I'd like to replicate that on the new (single instance) box.

I did not realize that you already had a PBIRS instance. I thought you were upgrading from SSRS to PBIRS.

So if you want both /reports and /powerbireports to take users to the PBIRS portal page then I think you would need to setup one of these as the "primary" web url in the Report Server Configuration Manager. Then you would need to setup the other url as a site in IIS and either configure a re-direct or url re-writing rules to point to the "primary" url. I'm not aware of any native option in PBIRS that would allow it to run the portal on two different urls.