I am trying to connect Power BI to BigQuery, but am getting the error below preventing this. I had previously been able to connect without issue, but in the last month have been unable to due to this error.
I have updated Power BI to the latest version, tried the instructions mentioned in the solution here (https://community.powerbi.com/t5/Desktop/Bigquery-connection-error/td-p/1602196), but nothing has worked.
How can I get around this SSL verification issue?
Error Message: Details: "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate. ERROR [HY000] [Microsoft][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate."