PowerBi Service to Azure VM Sql

Andrew Bilham 0

Good Morning,

I am trying to connect to a SQL thats hosted on a Azure VM.

Can anyone confirm that Service Tags and Ports I need to add to allow the connection?

Thank you

kobulloc-MSFT 23,811 Reputation points Microsoft Employee

2024-01-10T16:46:03.2933333+00:00

Hello, @Andrew Bilham !

I've updated the tag to get this in front of the correct people. It looks like TCP 1433, 4022, 135, 1434, and UDP 1434 are used:

https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16
Andrew Bilham 0 Reputation points

2024-01-10T17:06:46.8+00:00

Thank you.

do you know the correct Service Tags?
kobulloc-MSFT 23,811 Reputation points Microsoft Employee

2024-01-10T19:26:48.1933333+00:00

No worries! I just updated the tag to SQL Server on Azure Virtual Machines.
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee

2024-01-11T17:09:16.3233333+00:00

@Andrew Bilham
Thank you for reaching out. Are you trying to connect to a SQL VM on Azure from Power BI? Regards, Oury
Andrew Bilham 0 Reputation points

2024-01-11T17:22:16.8133333+00:00

@Oury Ba-MSFT Yes is a azure VM with a SQL server installed. not a AzureSQL And i am trying to connect using powerbi service (power query via a dataflow)
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee

2024-01-12T17:23:51.13+00:00

@Andrew Bilham
Have you gone through the below doc? https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/ways-to-connect-to-sql?view=azuresql
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee

2024-01-13T00:09:21.7433333+00:00

@Andrew Bilham One question Is your virtual machine created with public or private network access.

Regards, Oury
Andrew Bilham 0 Reputation points

2024-01-15T09:22:20.4666667+00:00

@Oury Ba-MSFT Hi it is public access cheers

1 answer

Oury Ba-MSFT 16,731 Reputation points Microsoft Employee

2024-01-16T19:00:43.93+00:00

@Andrew Bilham
You will need to have gateway installed in order to connect from PBI Service. Installed and configured PBI Gateway. https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install Power BI expects a gateway for on-prem SQL Server connector. If not provided, you may encounter an error if you try to create a connection on PQO. Connection could not be created. This may mean it is not accessible from this network or at this URI, or that a gateway is required to access this data source.

Regards, Oury
Please sign in to rate this answer.
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee

2024-01-16T20:09:41.69+00:00

@Andrew Bilham Please don't forget to mark as accept answer if the reply was helpful. Regards, Oury
Sign in to comment

Share via

PowerBi Service to Azure VM Sql

1 answer