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

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.