topic Re: Links in Subscribed Reports using Hostname in Report Server

Links in Subscribed Reports using Hostname

walkerd — Tue, 31 Jul 2018 22:50:29 GMT

When a report is emailed to an end user and they've checked the "Include Link" the link is created using the hostname of the server rather than the FQDN.

In rsreportserver.config I've set the <UrlRoot> attribute in the <Service> node to be the FQDN of the report server: ie: <UrlRoot>https://reportservername.domain.edu/ReportServer</UrlRoot>

I've rebinded the certificate just to make sure it wasn't a flaky bind. It is a wildcard cert, but it works for everything else just fine.

Does PBIRS ignore the <UrlRoot> attribute? Anyone else seeing this issue?

Re: Links in Subscribed Reports using Hostname

jre1960 — Mon, 18 Mar 2019 12:51:26 GMT

I have the same problem in PBIRS 2019 January, also using a wildcard cert.
PBIRS ignores the <UrlRoot> attribute.

Re: Links in Subscribed Reports using Hostname

Anonymous — Mon, 27 May 2019 12:47:50 GMT

I also have come across this problem and I'm using a wildcard certificate. Has anyone found a workaround for this problem? I've installed Power BI Report Server May 2019 version.

Re: Links in Subscribed Reports using Hostname

d_gosbell — Tue, 28 May 2019 23:42:14 GMT

I think I found the fix for this. If you look in the most recent ReportingServicesService_<datetime>.log file I saw lines like the following:

configmanager!WindowsService_0!134c!05/29/2019-09:20:49:: i INFO: Using report server internal url https://<server FQDN>/ReportServer.
configmanager!WindowsService_0!134c!05/29/2019-09:20:49:: i INFO: Using report server external url http://<server machine name>:80/ReportServer.

Notice that the external url is listed as being the machine/hostname.

It's not very well documented (in fact the docs claim that its only Sharepoint that uses this setting) but I found that adding both ReportServerUrl and ReportServerExternalUrl settings in the rsreportserver.config file fixed this issue.

These setting needs to be nested in the <UI> element (see below)

<Configuration>
       ....
	<UI>
		<ReportServerUrl>https://<fqdn>/ReportServer</ReportServerUrl>
		<ReportServerExternalUrl>https://<fqdn>/ReportServer</ReportServerExternalUrl>
		<PageCountMode>Estimate</PageCountMode>
	</UI>
       ....
</Configuration>

After adding these settings I think you need to stop then start PBIRS for them to take effect. Make sure to take a backup copy of your config file and check the most ReportServerService_<date>.log file after re-starting PBIRS as if you introduce any errors PBIRS may not start up properly, but you should find the reason in this log file.

Re: Links in Subscribed Reports using Hostname

jre1960 — Wed, 29 May 2019 06:39:05 GMT

I already had ReportServerUrl tag set, but the trick to fix this was the ReportServerExternalUrl tag
Thanks d_gosbell!

Re: Links in Subscribed Reports using Hostname

Anonymous — Wed, 29 May 2019 08:57:32 GMT

Yes !!

That worked. Thank you so much.

Regards,

Ewan.