topic Re: Unable to connect to DB from Service in Report Server

Unable to connect to DB from Service

V_Jith — Tue, 10 Jun 2025 05:51:01 GMT

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!!!

Re: Unable to connect to DB from Service

BhavinVyas3003 — Tue, 10 Jun 2025 10:11:01 GMT

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.

Re: Unable to connect to DB from Service

v-sshirivolu — Mon, 07 Jul 2025 09:30:09 GMT

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

Re: Unable to connect to DB from Service

v-sshirivolu — Thu, 24 Jul 2025 04:24:03 GMT

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.

Re: Unable to connect to DB from Service

v-sshirivolu — Thu, 24 Jul 2025 04:23:43 GMT

Hi V_Jith ,

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

Re: Unable to connect to DB from Service

v-sshirivolu — Thu, 24 Jul 2025 04:23:21 GMT

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.

topic Re: Unable to connect to DB from Service in Report Server

Unable to connect to DB from Service

Re: Unable to connect to DB from Service

Re: Unable to connect to DB from Service

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

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

Re: Unable to connect to DB from Service

Re: Unable to connect to DB from Service

Re: Unable to connect to DB from Service

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

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