---
title: Connect Microsoft Power BI to Tinybird
meta:
  description: This guide covers the steps to connect Microsoft Power BI to Tinybird using the ClickHouse® HTTP interface.
headingMaxLevels: 2
---

# 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.

{% callout type="info" %}
The ClickHouse® connection to Tinybird is read-only. You can use it to query and analyze data from your Tinybird data sources, but you cannot modify data through this connection.
{% /callout %}

## Prerequisites

- [Microsoft Power BI](https://www.microsoft.com/en-us/download/details.aspx?id=58494)
- A Tinybird workspace with data sources
- A Tinybird Auth Token with scopes `WORKSPACE:READ_ALL` and optionally `ORG_DATASOURCES:READ`. See [how to create it](../clickhouse-interface#auth-token-requirements).

## Install the ODBC Driver

Download the most recent [ClickHouse® ODBC release](https://github.com/ClickHouse/clickhouse-odbc/releases).

Execute the .msi installer and follow the wizard.

## Create a new connection

1. On Power BI Desktop click **Get Data**

{% image src="/img/powerbi01.png" alt="ClickHouse® connector configuration" caption="ClickHouse® connector configuration" /%}

1. Select **ClickHouse®**.

{% image src="/img/powerbi02.png" alt="ClickHouse® connector configuration" caption="ClickHouse® connector configuration" /%}

3. Fill in the ClickHouse® database credentials.

### Connection settings

```bash
Host: {% user("clickhouseHost") %}
Port: 443  # For HTTPS connections
Database Name: <WORKSPACE_NAME>  # Your workspace name
User name: <WORKSPACE_NAME>  # Your workspace name
Password: {% user("JWT") %}  # Your Tinybird auth token
```

Use **DirectQuery** for querying Tinybird directly.

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

{% callout type="info" %}
See the list of [ClickHouse® hosts](../clickhouse-interface#clickhouse-interface-hosts) to find the correct one for your region.
{% /callout %}

## Troubleshooting

Failed to verify certificate chain: CA not trusted

{% image src="/img/powerbi03.png" alt="ClickHouse® connector configuration" caption="ClickHouse® connector configuration" /%}

You need to install the root and intermediate certificates in your local Windows machine (see [issue](https://github.com/ClickHouse/clickhouse-odbc/issues/443#issuecomment-2507243488))

Follow this steps:


Open the ClickHouse® host URL in your browser:

```
{% user("clickhouseHost") %}
```

Export certificates from the browser:

{% image src="/img/powerbi04.png" alt="ClickHouse® connector configuration" caption="ClickHouse® connector configuration" /%}

{% image src="/img/powerbi05.png" alt="ClickHouse® connector configuration" caption="ClickHouse® connector configuration" /%}

{% image src="/img/powerbi06.png" alt="ClickHouse® connector configuration" caption="ClickHouse® connector configuration" /%}

{% image src="/img/powerbi07.png" alt="ClickHouse® connector configuration" caption="ClickHouse® connector configuration" /%}

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](../clickhouse-interface)
- [Tinybird Auth Token management](/classic/administration/auth-tokens)