Forum Discussion
SSL verification fail
Hi, I keep getting this error ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" en...
It appears that you're trying to connect to an SSL enabled datasource (MS SQL/Azure SQL) and the SSL handshake is failing because the hostname entered in the Power BI connection does not match the name (cn) value on the SSL certificate.
In Power BI desktop, define your connection using the fully qualified name of the MS SQL/Azure SQL that you're using as a data source (no IP addresses) and try to refresh.