Forum Discussion

NicholasA's avatar
NicholasA
New Member
3 years ago

How to connect Power BI to an SQL Server running on a private Azure VM

I'm trying to connect Power BI to a SQL Server that is on an Azure VM that has no public IP. The The current idea would be to have one vnet on Azure for the Power BI Gateway which is installed on its...
Need Help
Tutorial Requests
Martin_D's avatar
Martin_D
Icon for Solution Sage rankSolution Sage
3 years ago

Hi NicholasA ,

 

Somehow the gateway and the SQL-Server must be able to communicate. Using 2 NICs on the gateway VM, adding them to two different subnets of the gateway vnet and linking the two vnets (gateway & SQL-Server) in a network group would be an option that might allow to statisfy your security needs.

 

https://learn.microsoft.com/en-us/azure/virtual-machines/windows/multiple-nics#:~:text=A%20common%20scenario%20is%20to%20have%20different%20subnets%20for%20front%2Dend%20and%20back%2Dend%20connectivity.

 

BR

Martin