Forum Discussion

PremK's avatar
PremK
Resolver I
1 year ago

Gateway - MS SQL Server ( On-Premises )

Im using MS SQL Server as Data Base, which is on-premises server.

I had build a report in Power BI using this Data base.  

To refresh this data set in PBI Service,  Is it possible to connect this data base using PBI's inbuilt cloud gateway connection OR do i need to install  On-Premises gateway in the local machine were  MS SQL Server hosted ??

Need Help

8 Replies

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    1 year ago

    Hi! PremK 

     

    The best practice is to have your GW on a virtual machine so it keeps on running, having it on your machine means, it stops working once you log off and this will lead to failure in data refreshes.

     

     

    • PremK's avatar
      PremK
      Resolver I
      1 year ago

      you mean to say i need to install GW in the VM were the MS SQL Server is insatlled, right ?

       

      • sergej_og's avatar
        sergej_og
        Super User
        1 year ago

        No, pls don't do it this way!
        Use one stand-alone VM, only for your GW client.
        This VM (with your GW) should then has FW-rule to be able to connect to your SQL Server.

        Pls don't use GW on the same VM where SQL Server is stored.

        Regards 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for the reply from AnkitKukreja ,R1k91 and sergej_og.

     

    Hi PremK , 

     

     May I ask if you have gotten this issue resolved? If it is solved, please mark the valid suggestions provided by other users as solutions or share your solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster . Thank you very much for your kind cooperation!

     

    Best Regards,
    Zhu