Forum Discussion

sanjoyleo's avatar
sanjoyleo
Helper I
8 years ago
Solved

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

  • bergjm2's avatar
    bergjm2
    8 years ago

    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

  • ginascott's avatar
    ginascott
    Regular Visitor

    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's avatar
      bergjm2
      Helper I

      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's avatar
        sanjoyleo
        Helper I

        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  ?