Forum Discussion
SQL in DMZ (and gateway)
Hey
I have a SQL in a DMZ. I have installed the powerbi data gateway on the server.
How do I create a dataset - when my local PowerBi is unable to connect to the local SQL server?
4 Replies
HEllo MikeyDK1 ,
then you need to install power bi on the server and then connect to sql on the server so you could import the data to power bi.
If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť
Follow me on Linkedin
Vote For my Ideađź’ˇSo I need to install the PowerBI Desktop on the server?
MikeyDK1 , Yes and you connect to sql there then you import the data into power bi and work.
If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť
Follow me on Linkedin
Vote For my Ideađź’ˇIf you have distributed architecture (meaning different VMs, local machines etc.) you have to enable a communication between you components - usually through firewall rules.
We also have distributed architecture and it works fine.
Gateway in on one VM, SQL Server on other VM, Oracle on third VM etc.
Make sure communication between your involved VMs is allowed --> Firewall rules?
So it is not mandatory to install Power BI on the machine where your SQL Server is running.
Regards
