Forum Discussion
Unable to connect to DB from Service
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!!!
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-instanceIf 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
5 Replies
- BhavinVyas3003
Super User
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.
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-instanceIf 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
