Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
NicholasA
New Member

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 own Azure VM and another vnet that holds the Azure VM with the SQL Server. For security reasons the SQL Server is on an Azure VM without a public IP, just the private IP, so that the SQL Server cannot be accessed from the outside. However, Power BI still needs to be able to access it to generate reports.

 

Using Power BI Gateway, how can I get Power BI to be able to utilize the SQL Server (on an Azure VM) which is in a different vnet?

1 REPLY 1
Martin_D
Super User
Super User

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

 

BR

Martin

github.pnglinkedin.png

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.