Forum Discussion
Confusing PowerBI message about unencrypted connection
I appreciate your attempt to help but those pages describe issues with certificate chains and that has nothing to do with my question.
Do you have the solution for this? I am facing the same issue and landed up here tryna find a solution...
No, unfortunately, I have never found a definitive explanation for what's happening here. My assumption (until someoone can confirm otherwise) must be that SQL Server encryption of traffic is broken and untrustworthy in some fundamental way. At least on the surface, it appears to allow non-encrypted connections even though the option to force encryption is turned on at the server. I don't understand what's going on.
So..there is no workaround for this issue? Was thinking if DBA could help it out with 🙂
If you're seeking a workaround, the way we got rid of this message was the add the FQDN to the connection string. Because there's an SSL cert in place, the connection must include the same domain as the cert. That part was easy to fix and not really my question.
What bothered me was that the user reported he could choose to connect anyway (clicking OK in the dialog) which leads me to believe it's allowing non-secure connections despite the settings on the server supposedly forcing encryption. Just not sure what to make of that.