Ports needed to connect On-premises data gateway with Azure SQL server

[borys864]

Dear community

We are planning to run our Azure SQL server and access it in Power BI SaaS using On-premises data gateway. 

Power BI and On-premises data gateway are already setup and are servicing a number of on-prem SQL servers but now we want to try Azure SQL server. Due to restrictions our Azure SQL server is not publicly exposed and it we plan to put it behind VNET and only allow access to it from On-premises data gateway. Now question is what ports we need to open between On-premises data gateway and Azure SQL server?

Internally we have a vnet peering from on-prem to Azure but I need to know what ports are required for successful On-premises data gateway connection towards Azure SQL server.

[v-saisrao-msft · Accepted solution]

Hi @borys864 

Thank you for reaching Microsoft forum community.

As per your query which Ports needed to connect On-premises data gateway with Azure SQL server 

To enable communication between the On-premises data gateway and your Azure SQL server when it is behind a VNET and not publicly exposed, you need to ensure that the appropriate network ports are open for the On-premises data gateway to connect to the Azure SQL server. 

Below are the key ports you need to open: 

• TCP port 1433: This is the default port used by SQL Server, including Azure SQL Database. You'll need this port to be open between the On-premises data gateway and the Azure SQL server. 
• TCP port 443: This port is used for HTTPS communication with the Power BI service. The On-premises data gateway needs to communicate with Power BI over HTTPS, and this port is essential for the gateway to interact with Power BI and send data securely. 

If this post clears your issue, please give us Kudos and consider marking Accepting it as a solution to guide other members in finding it more easily. 

[borys864]

@v-saisrao-msft so between on-prem gateway and azure sql servier only one, 1433 port is needed? 

Thank you for your answer. As mentioned before on-prem gateway setup with power bi is already in place. 

[v-saisrao-msft]

Hi @borys864 

We greatly appreciate your efforts and addressing your concerns. Here is the breakdown of your points:
As you mentioned, the 1433 port is necessary between the on-prem gateway and Azure SQL Server because it facilitates communication with the Azure SQL Database.

[GilbertQ]

Hi @borys864 

Here is a way to configure access to azure sql server. VNET Data Gateway for Microsoft Power BI and SQL Server. | by Dileepa Mabulage | Medium

[borys864]

I explicitly stated that we have On-premises data gateway. At the moment usage of PowerBI VNet Data Gateway is not an option.