Unable to connect to DB from Service

[V_Jith]

My DB is Azure SQL managed Instance. I am able to connect from Power BI desktop. But when configuring the gateway cloud connection from Power BI Service. I am not able to. 

Send Help!!!

[v-sshirivolu · Accepted solution]

Hi @V_Jith ,
Thanks for reaching out to the Microsoft fabric community forum.

Since your Azure SQL Managed Instance is in a private network, Power BI Service can't access it directly. You’ll need to use an On-premises Data Gateway or enable public access.

For detailed setup, please refer to these official Microsoft resources:

Go Through These Official Microsoft Documentations

Overview of the On-premises data gateway
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

Tutorial: Set up a SQL Server data source using a data gateway
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
Provides step-by-step instructions to install the gateway and configure SQL Server connections in Power BI Service.

Power BI with Azure SQL Managed Instance – Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/918006/power-bi-with-azure-sql-managed-instance

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team

[v-sshirivolu]

Hi @V_Jith   ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-sshirivolu]

Hi @V_Jith ,

Just wanted to check if you had the opportunity to review the suggestion provided?

[v-sshirivolu]

Hi @V_Jith ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[BhavinVyas3003]

Hi @V_Jith ,

• You must use an On-premises Data Gateway (standard mode) to bridge Power BI Service to Azure SQL Managed Instance.
• Install On-premises Data Gateway on a VM that has network access to the Azure SQL MI.
• In Power BI Service → Manage Gateways, add a SQL Server data source using the FQDN of the MI.

Ensure:

• Gateway VM can access MI on port 1433.
• Authentication uses SQL auth or OAuth2 with HTTPS.
• NSG and firewall allow the traffic.