Encryption Support when I connect to DB in Power BI Desktop

Hi badkor3434 , hello pborah and saud968, thank you for your prompt reply!

Are you currently using the October 2024 version of Power BI Desktop?

If so, this issue has been reported internally.

As a workaround, we suggest connecting to PostgreSQL in the Power BI Service to create a dataflow, which you can then link to Power BI Desktop.

Alternatively, you can temporarily revert to a previous version to resolve this issue.

Thank you for your patience as we work on a fix. I will keep you updated with any new information.

Best regards,

Joyce

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

Here are a few steps you can try to resolve this issue:

Check Encryption Settings:
Go to File > Options and Settings > Data Source Settings in Power BI Desktop.
Select your data source and click on Edit Permissions.
Ensure that the Encrypt connections option is checked if your database requires encrypted connections.
Server Name Mismatch:
Sometimes, this error can occur if the server name in the connection string doesn’t match the server name on the SSL certificate. Ensure that the server name you are using in Power BI Desktop matches exactly with the one on the certificate.
Update Power BI Desktop:
Make sure you are using the latest version of Power BI Desktop. Sometimes, updates include fixes for such issues.
Recreate the Connection:
Try deleting the existing connection and creating a new one to see if that resolves the issue.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

Check Encryption Settings: I was try, it's not helped 😞

Server Name Mismatch: It's so srtrange, because I using Azure PostgreSQL. If they update certifacate and not update windows certificate base I will broke my hand. Because I really tired solving problem with microsoft products. really... But I will check this point. thank you

Recreate the Connection: Not working 😞 Same problem

Update Power BI Desktop: I don't see new updates 😞

This is an issue with your SQL backend, not necessarily Power BI. Power BI sends an encrypted connection request to the server and if the server doesn't have it enabled, you will get that message. Check with your db admin.