Error creating Power BI Data Gateway connection

[extol7]

I am trying to create a Gateway connection to a Production SQL server VM in Azure.  We have similar connections working fine, and firewall settings are fine, but we are getting this error:

The SQL source doesn't support encrypted connections.

Cluster URI: https://api.powerbi.com
Status code: 400

This server isn't much different than other ones we have and we are able to create a connection for.  Any thoughts/Ideas?  I've spent a lot of time on this and have not found a fix for this.

[extol7 · Accepted solution]

Thank you @lbendlin  and @v-tsaipranay , the resolution was that I needed to an an SSL Certficate to the Cert Store on the SQL server in Azure, than in SQL configuration manager > add the certificate.  After that, We were able to sucessfully create a Data Gateway in Power BI Admin Center.  

[v-tsaipranay]

Hello @extol7 ,

Thank you for the update, and we're glad to hear that the issue has been resolved. 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.

Thank you.

[v-tsaipranay]

Hi @extol7 ,

Thank you for reaching out regarding the issue you're facing when trying to establish a Power BI Data Gateway connection to your SQL Server VM in Azure.

Based on the error message indicating that the SQL source doesn't support encrypted connections, it appears that the root cause might be related to encryption settings on your SQL Server. Since you've mentioned that similar connections to other servers are working fine, it suggests that the general configuration and firewall settings are in place, but this specific SQL Server might have different encryption settings.

We would like to thank @lbendlin  for helpful suggestion provided as mentioned that in many production environments, encryption might be disabled for performance reasons. This could be the case with your SQL Server. We recommend reaching out to your SQL Server administrators to confirm whether SSL/TLS encryption is enabled on this server.

If encryption is indeed disabled, enabling it should allow the Power BI Data Gateway to establish a secure, encrypted connection, which is a requirement for proper communication between Power BI and SQL Server.

Once the encryption settings are verified or enabled, we recommend testing the connection again through the Power BI Data Gateway to confirm that the issue is resolved.

Please refer the following documentation for detail information: Manage a SQL Server data source - Power BI | Microsoft Learn

I hope this will resolve your issue, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.

[v-tsaipranay]

Hi @extol7 ,

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. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[lbendlin]

Check with the SQL server admins. Sometimes production servers have encryption disabled for performance reasons.