topic Re: PowerBI Server Reverse Proxy in Report Server

PowerBI Server Reverse Proxy

CoderCodingCode — Thu, 18 Oct 2018 12:32:05 GMT

Has anybody ever successfully setup a reverse proxy to an internal Power BI Server? I'm trying to use IIS10 and URL Rewrite. I want to make a few reports publically accessible without exposing the entire PowerBI server.

Basically I want users to visit a URL on my public web server and it will display one specific report on my private internal Power BI Rerport server.

Just curious if anybody has ever set this up before.

Re: PowerBI Server Reverse Proxy

Xriz — Tue, 15 Oct 2019 11:09:56 GMT

Hello there,

I am trying to set up the same. Did you manage to realize your request CoderCodingCode ?

Re: PowerBI Server Reverse Proxy

joseddg — Sun, 10 May 2020 18:08:59 GMT

Also trying to do the same. Were you guys able to achieve this?

Re: PowerBI Server Reverse Proxy

fimiki — Tue, 26 May 2020 17:03:35 GMT

I added a custom middleware class to our website that does this for our PowerBI Report Server using the code given in this article as a template. It does a few more things, like inject basic auth credentials for anonymous access and manipulate the content of the response to hide or disable the PowerBI navigation items. It took a solid week of effort, but I hadn't had much prior exposure to proxies or working with headers and cookie content.

Re: PowerBI Server Reverse Proxy

Xriz — Tue, 26 May 2020 19:33:17 GMT

Hello and welcome fimiki ,

that sounds good. Unfortunately I don't understand much of coding classes. Maybe you can write a Technote or a guide how to do this.

Regards Xriz

Re: PowerBI Server Reverse Proxy

rks — Mon, 29 Jun 2020 08:51:22 GMT

Hi, was able to setup my reverse proxy. Now IIS proxies the request to the outside URL to my local server on which I have installed PBI Reporting Service.

I produced the following steps:

* Inside the Default Website I have added a new Application with the same path like I have configured for the Web Portal URL

* I created a rewrite rule:

<?xml version="1.0" encoding="UTF-8"?> <configuration> <system.webServer> <rewrite> <rules> <clear /> <rule name="ReverseProxyInboundRule1" enabled="true" stopProcessing="true"> <match url="(.*)" /> <conditions logicalGrouping="MatchAll" trackAllCaptures="false" /> <action type="Rewrite" url="http://localhost/Reports/{R:1}" appendQueryString="true" /> </rule> <rule name="ReverseProxyInboundRule2" stopProcessing="true"> <match url="(.*)" /> <conditions logicalGrouping="MatchAll" trackAllCaptures="false"> <add input="{CACHE_URL}" pattern="^(https?)://" /> </conditions> <action type="Rewrite" url="{C:1}://localhost/Reports/{R:1}" /> </rule> </rules> </rewrite>    </system.webServer> </configuration>

(Replace localhost with whatever IP or URL of the server hosting the web portal).

Then, it kind of worked.... I was able to browse the Web Portal and click here and there... However, when trying to open a report I ran into another issue:

When opening a report a new request is made to www.url.de/powerbi/?queryblabla

When opening the same report locally it works, but the request shows this url: http://localhost/Reports/powerbi/?queryblabla

Apparently the rewritten URL is omitted at this stage and I am not fluent enough with IIS to also rewrite the URL to www.url.de/Reports/powerbi/?queryblabla

I am not sure whether or not this is the actual reason for the error. But I'd like to find out.