Where to install the Gateway and how to use it.

[Anonymous]

We have 3 SQL Servers.  Dev, QA and Prod.  The Prod server is really restrictive as far as Group Policy and the firewall.

I am trying to use Power BI, I have the desktop installed.  When I publish, it suceeds, but can't connect to data source because unable to find gateway.

There may be a Gateway in our organization, but unsure on what computer it may be installed, if one is even installed.  If I were to install a Gateway, where should I install it?  On one of my threee SQL Servers?  On all three?  On my machine?  Once it is installed how do I tell Power BI...  "This is where the Gateway is installed", so it can be used.

I am using a free version, but beleive we do have Pro versions available.  Any help and or advice appreciated.

Thanks,

Mike

[GilbertQ · Accepted solution]

Hi there

The best advice is to install the Gateway on a separate server is ideal. This is because it can consume CPU & memory when doing the refreshing of the data.
With that being said you could install it onto another server.

When you complete the install it will ask you to log in and make you the Default Administrator for the Gateways and it will appear in the Power BI Service.

Here are more details: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

[GilbertQ · Accepted solution]

Hi there

The best advice is to install the Gateway on a separate server is ideal. This is because it can consume CPU & memory when doing the refreshing of the data.
With that being said you could install it onto another server.

When you complete the install it will ask you to log in and make you the Default Administrator for the Gateways and it will appear in the Power BI Service.

Here are more details: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

[Anonymous]

Thanks for the info...

So at this point, we are installing a new Prod server.  Currently I can't deploy SSIS packages, SSRS reports or hardly anything because the server is locked down with group policy and behind a firewall.  I had to jump through all these hoops to even get someone to look at GPO settings.  Am I going to have the same problems with a gateway?  Am I going to have issues with it talking to the Prod server if its on another machine?  Are there double hop issues like with SSRS reports?

Thanks again,

Mike

[GilbertQ · Accepted solution]

Hi there

There will be no double hop issue if you install it on another server.

And as per best practise I would suggest to have it installed on its own server.