Forum Discussion
Solved
Encryption Support Message
Hi, I get the following message when I connect to our on-prem SQL database with PowerBI or SSAS: Encryption Support We were unable to connect to the data source using an encrypted connection...
whereismydata wrote:hi, yes, but that means that our sql server does not support encrypted connection at the moment?
No, your SQL Server instance might require configuration changes to support encryption. I would check with your DBA.
It is because the connections are encrypted by default but it can be turned off using File->Options and Settings -> Data Source Settings > SQL Server data source > Edit and uncheck "Encrypt Connections" option.
Here is a detailed answer - https://community.powerbi.com/t5/Desktop/connect-to-SQL-DB-prompt-quot-The-data-source-you-re-trying-to/td-p/24296