gateway installation

[sanjoyleo]

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

[ginascott]

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 · Accepted solution]

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]

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  ?