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