ODBC: ERROR [HY000] Certificate validation error: Failed to verify certificate chain: CA not trusted

[kleinmantara]

Hello, I have the following error on a Power BI Gateway:

ODBC: ERROR [HY000] Certificate validation error: Failed to verify certificate chain: CA not trusted

We installed the both drivers:

• https://github.com/ClickHouse/clickhouse-odbc
• https://github.com/ClickHouse/power-bi-clickhouse

The PowerBI Gateway ist connected to the Power BI Web. The Status is online.

The Clickhouse driver is added as "User-configured data connectors" and is also displayed as a connection type in Power BI Web. When I then try to add a new "Connection" in Power BI Web, I get the same error message as above:

Details: ClickhousePowerBI_Gateway1: ODBC: ERROR [HY000] Certificate validation error: Failed to verify certificate chain: CA not trusted

I have already added the same in the issue SSL error in the Repo power-bi-clickhouse. But I think this is the better place