cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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..

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..

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
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 324 members 3,292 guests