cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanjoyleo Regular Visitor
Regular Visitor

gateway installation

Hello  ,

 

I developed Report/Dashboard which will take data from a MS SQL Sever (with in network) . As per my knowledge Gateway needs to be installed & source config done only in that Host machine (say X )  where SQL Server is there .

 

Now question is can we install Gateway not physically in the X but some other machine (Y) which is acting a gateway to that SQL Server machine ..basically another m/c which might be connected to that SQL Sever ? I feel no.. can you please confirm ?

 

in case any solution like in same node/cluster..something..

1 ACCEPTED SOLUTION

Accepted Solutions
bergjm2 Regular Visitor
Regular Visitor

Re: gateway installation

As long as the machine you are installing the gateway on can see the database, say through SQL Serv Management Studio, it will work..

View solution in original post

3 REPLIES 3
ginascott Frequent Visitor
Frequent Visitor

Re: gateway installation

If you are refering to the on-prem Power BI gateway - it is recommended to have it installed on a separate machine. If that machine goes down you will have no access via powerbi desktop to your data.

It is fairly easy to congiure and the new updates to it, it can now be clustered.

I hope that helps!

bergjm2 Regular Visitor
Regular Visitor

Re: gateway installation

As long as the machine you are installing the gateway on can see the database, say through SQL Serv Management Studio, it will work..

View solution in original post

sanjoyleo Regular Visitor
Regular Visitor

Re: gateway installation

Hello , Thanks for your reply  !

 

Are you then saying below flow would work ? Installation of Gateway and DB Source configuration will be as it is normal  ?

 

diag.png

 

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 109 members 1,548 guests
Please welcome our newest community members: