Forum Discussion
Confusing PowerBI message about unencrypted connection
I have a user connecting PowerBI to a SQL Server which has an SSL cert and is set to force encryption. He entered the server name without the FQDN and it displayed the message shown below. He claimed...
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.