Last update: 2025-12-17T09:59:55.000Z
Content:
---
title: "Connect Microsoft Power BI to Tinybird · Tinybird Docs"
theme-color: "#171612"
description: "This guide covers the steps to connect Microsoft Power BI to Tinybird using the ClickHouse HTTP interface."
inkeep:version: "forward"
---




# Connect Microsoft Power BI to Tinybird [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-powerbi#connect-microsoft-power-bi-to-tinybird)

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

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.

## Prerequisites [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-powerbi#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 [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-powerbi#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 [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-powerbi#create-a-new-connection)

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



<-figure->
![ClickHouse® connector configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fpowerbi01.png&w=3840&q=75)

<-figcaption->
ClickHouse® connector configuration

</-figcaption->


</-figure->
1. Select**  ClickHouse**  .



<-figure->
![ClickHouse® connector configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fpowerbi02.png&w=3840&q=75)

<-figcaption->
ClickHouse® connector configuration

</-figcaption->


</-figure->
1. Fill in the ClickHouse database credentials.

### Connection settings [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-powerbi#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.

See the list of [ClickHouse hosts](../clickhouse-interface#clickhouse-interface-hosts) to find the correct one for your region.

## Troubleshooting [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-powerbi#troubleshooting)

Failed to verify certificate chain: CA not trusted



<-figure->
![ClickHouse® connector configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fpowerbi03.png&w=3840&q=75)

<-figcaption->
ClickHouse® connector configuration

</-figcaption->


</-figure->
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:

clickhouse.tinybird.co Export certificates from the browser:



<-figure->
![ClickHouse® connector configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fpowerbi04.png&w=3840&q=75)

<-figcaption->
ClickHouse® connector configuration

</-figcaption->


</-figure->


<-figure->
![ClickHouse® connector configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fpowerbi05.png&w=3840&q=75)

<-figcaption->
ClickHouse® connector configuration

</-figcaption->


</-figure->


<-figure->
![ClickHouse® connector configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fpowerbi06.png&w=3840&q=75)

<-figcaption->
ClickHouse® connector configuration

</-figcaption->


</-figure->


<-figure->
![ClickHouse® connector configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fpowerbi07.png&w=3840&q=75)

<-figcaption->
ClickHouse® connector configuration

</-figcaption->


</-figure->
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 [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-powerbi#learn-more)

- [  ClickHouse Interface overview](../clickhouse-interface)
- [  Tinybird Auth Token management](/docs/classic/administration/auth-tokens)


