In both power BI desktop and power BI report server, we are suddenly experiencing the following error when trying to connect to our spark cluster.
Processing error: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed. Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net Activity ID: 32c52ebd-55ff-4244-85f8-9363322c2504 Request ID: 8b039453-a0e6-7449-d060-919d94415adf Time: 2021-04-30 20:57:25Z
The datasets were connecting without issue mere hours ago.
Tableau has no problems connecting and extracting data.
Chrome and IE running on the same computer as power BI desktop are accepting the certificate without issue. If there is a problem with a certificate, then clients should expose the entire received certificate (and chain) as well as providing detailed information about what they dislike about the cert.
We confirmed the certificate received by chrome and powerbi desktop were identical using wireshark.