How to access Managed Clickhouse (Yandex.Cloud) from PowerBI

Managed Clickhouse cluster with public address is only reachable with SSL enabled, so

1. Download and install Yandex.Cloud certificate

Into Trusted Root Certification Authorities

2. Install Clickhouse ODBC driver

clickhouse-odbc-1.1.10-win64.msi

See more at clickhouse-odbc releases

3. Configure ODBC connection (Windows)

Get Data in PowerBI

4. From ODBC – choose your connection

Voila. By the way, I use Mac, and to work with PowerBI I have to spin up Windows VM 😒

#powerbi #bi #clickhouse