Hello Team, I wanted to create cloud connection for Azure SQl managed instance

[Shivakumarh]

Hello Team,

I wanted to create cloud connection for Azure SQl managed instance, but while trying to create cloud connection i am getting the below error 

Unable to create connection for the following reason:
We could not access the data source. Please make
sure you have permission to access the data source
and that your credentials are correct.
Details:
A network-related or instance-specific error occurred while
establishing a connection to SQL Server. The server was not
found or was not accessible. Verify that the instance name
is correct and that SQL Server is configured to allow
remote connections. (provider: TCP Provider, error: O - A
connection attempt failed because the connected party did
not properly respond after a period of time, or established
connection failed because connected host has failed to
respond.

i am able to connect to the same data source in Desktop and in the same machine and i am able to conenct to ssms with same credentails.
What is the issue i am not able to understand can any one help on this.Thanks

[v-ssriganesh]

Hello @Shivakumarh,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-ssriganesh]

Hi @Shivakumarh,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @dinesh_7780 for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[dinesh_7780]

Hi @Shivakumarh ,

Power BI Desktop uses your local network.  Power BI Service Cloud Connections run from Microsoft’s cloud, not your VNET or your machine.

Because Azure SQL Managed Instance lives inside a private VNET, Power BI Service cannot access it directly unless you configure the correct connectivity path.

Please try below things to fix the issue.

If your security policy allows:

 1. Enable Public Endpoint on Azure SQL Managed Instance.

 2. Add firewall rules to allow Azure services & Power BI ranges.

3. Use that endpoint in Power BI cloud connection.

If  public endpoint cannot be enabled,

1.  Install an On-Premises Data Gateway on a VM inside the same VNET as SQL MI

or

2. Use Azure Gateway (VNET Data Gateway) if available in your Fabric tenant. This allows secure private connectivity without public exposure.

If my response as resolved your issue please mark it as solution and please give kudos.

Thanks,

Dinesh

[parry2k]

@Shivakumarh is there any firewall rules that are preventing the service from connecting to the SQL instance?