Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
V_Jith
Frequent Visitor

Unable to connect to Azure SQL managed Instance from service

V_Jith_0-1749534309030.png

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

2 ACCEPTED SOLUTIONS

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.

Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!

View solution in original post

Hi @V_Jith ,

Great question! Connecting Power BI Service to an Azure SQL Managed Instance often trips people up, even if it works fine in Power BI Desktop. Here’s what you need to check and set up for a successful connection:

  1. Use the On-premises Data Gateway:
    Power BI Service can’t directly connect to an Azure SQL Managed Instance; it needs the On-premises Data Gateway (standard mode). This gateway acts as a bridge between your cloud Power BI reports and the Azure SQL MI.

  2. Gateway Location:
    The gateway must be installed on a VM or server that has network access to your Azure SQL Managed Instance. The VM should be able to reach the MI over port 1433.

  3. Network and Security:

    • Make sure your VM’s firewall and NSG rules allow outbound traffic to the Azure SQL MI.
    • Sometimes, you may need to add the VM’s IP to the allowed list in the Azure SQL MI’s networking settings.
  4. Authentication:

    • Use SQL authentication or Azure AD (OAuth2 with HTTPS).
    • Verify that the credentials you use for the connection have the right permissions on the database.
  5. Gateway Setup in Power BI Service:

    • Register your gateway in Power BI Service under Manage Gateways.
    • Add a new SQL Server data source with the FQDN of your Managed Instance.
    • Test the connection from within Power BI Service to make sure it’s successful.

If you follow these steps and still run into issues, double-check the firewall and NSG settings, and make sure the gateway service is running properly on the VM.

Let us know if you need more detailed troubleshooting or run into a specific error message!
translation and formatting supported by AI

View solution in original post

9 REPLIES 9
v-prasare
Community Support
Community Support

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

 

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum  we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

v-prasare
Community Support
Community Support

Hi @V_Jith,

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue got resolved? or let us know if you need any further assistance here?

 

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

v-prasare
Community Support
Community Support

Hi @V_Jith,

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue got resolved? or let us know if you need any further assistance here?

 

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

v-prasare
Community Support
Community Support

Hi @V_Jith,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful

V_Jith
Frequent Visitor

V_Jith_0-1749535384506.png

 

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 ,

Great question! Connecting Power BI Service to an Azure SQL Managed Instance often trips people up, even if it works fine in Power BI Desktop. Here’s what you need to check and set up for a successful connection:

  1. Use the On-premises Data Gateway:
    Power BI Service can’t directly connect to an Azure SQL Managed Instance; it needs the On-premises Data Gateway (standard mode). This gateway acts as a bridge between your cloud Power BI reports and the Azure SQL MI.

  2. Gateway Location:
    The gateway must be installed on a VM or server that has network access to your Azure SQL Managed Instance. The VM should be able to reach the MI over port 1433.

  3. Network and Security:

    • Make sure your VM’s firewall and NSG rules allow outbound traffic to the Azure SQL MI.
    • Sometimes, you may need to add the VM’s IP to the allowed list in the Azure SQL MI’s networking settings.
  4. Authentication:

    • Use SQL authentication or Azure AD (OAuth2 with HTTPS).
    • Verify that the credentials you use for the connection have the right permissions on the database.
  5. Gateway Setup in Power BI Service:

    • Register your gateway in Power BI Service under Manage Gateways.
    • Add a new SQL Server data source with the FQDN of your Managed Instance.
    • Test the connection from within Power BI Service to make sure it’s successful.

If you follow these steps and still run into issues, double-check the firewall and NSG settings, and make sure the gateway service is running properly on the VM.

Let us know if you need more detailed troubleshooting or run into a specific error message!
translation and formatting supported by AI

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.

Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!

Hi,
I'm able to connect to SQL MI on power BI desktop but not on Power BI Service. Since SQL Managed Instance support cloud connection, I'm seeing the option to create a cloud connection to SQL MI from Power BI service but when I try to create the connection, I'm facing an error which is given below:

AntoF9_0-1754591552880.png

As for SQL MI, I have granted access to Power BI from NSG which is given below:

AntoF9_1-1754591743225.png

I'm still not able to create the cloud connection even specifying the port number in the connection.
Any suggestions to move forward?

Thanks!
Anto

BhavinVyas3003
Super User
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.

Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.