Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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.
BR
Martin
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |