cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Where to install the Gateway and how to use it.

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Where to install the Gateway and how to use it.

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

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

Highlighted
Super User
Super User

Re: Where to install the Gateway and how to use it.

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.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Where to install the Gateway and how to use it.

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

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

Anonymous
Not applicable

Re: Where to install the Gateway and how to use it.

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

Highlighted
Super User
Super User

Re: Where to install the Gateway and how to use it.

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.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,209)