Connect Microsoft Power BI to Tinybird¶

Microsoft Power BI can connect to Tinybird using the ClickHouse® Data Source, taking advantage of Tinybird's ClickHouse® HTTP protocol compatibility.

Prerequisites¶

• Microsoft Power BI
• A Tinybird workspace with data sources
• A Tinybird Auth Token with read permissions for the workspace data sources

Install the ODBC Driver¶

Download the most recent ClickHouse ODBC release.

Execute the .msi installer and follow the wizard.

Create a new connection¶

1. On Power BI Desktop click Get Data

1. Select ClickHouse.

3. Fill in the ClickHouse database credentials.

Connection settings¶

Host: clickhouse.tinybird.co
Port: 443  # For HTTPS connections
Database Name: <WORKSPACE_NAME>  # Your workspace name
User name: <WORKSPACE_NAME>  # Your workspace name
Password: <TOKEN>  # Your Tinybird auth token

Use DirectQuery for querying Tinybird directly.

You should see the workspaces and tables in the Navigator view.

Troubleshooting¶

Failed to verify certificate chain: CA not trusted

You need to install the root and intermediate certificates in your local Windows machine (see issue)

Follow this steps:

Open the ClickHouse host URL in your browser:

clickhouse.tinybird.co

Export certificates from the browser:

Install certificates in the local store:

• Win → write mmc → Run as administrator.
• File → Add/Remove Snap-in… → Certificates → Computer account → Local computer.
• Trusted Root Certification Authorities → Certificates → right click → All Tasks → Import… → select the root .cer file → Place in this store.
• Intermediate Certification Authorities → Certificates → import the intermediate .cer.

Close, save and restart Power BI Desktop

Learn more¶

• ClickHouse Interface overview
• Tinybird Auth Token management