---
title: How to connect your deployment to PowerBI in a Private Network
description: Learn how to connect your Scaleway Data Warehouse for ClickHouse® deployment within a Private Network to PowerBI.
tags: connect bi-tools deployment data warehouse ClickHouse® integrate integration VPC
dates:
  validation: 2026-03-11
  posted: 2026-03-11
---
import Requirements from '@macros/iam/requirements.mdx'

import powerbiVpcConnection from './assets/scaleway-powerbi-vpc.webp'


This page explains how to integrate your Data Warehouse for ClickHouse® deployment located in a Private Network with PowerBI Service.

PowerBI Service is a robust data visualization tool that allows users to create dynamic reports and dashboards from various data sources. Connecting your Data Warehouse for ClickHouse® deployment within a Private Network to PowerBI requires installing the Microsoft On-premises data gateway on a dedicated Windows Instance located in the same Private Network, and using the ODBC protocol.
<Lightbox image={powerbiVpcConnection} alt="" />

<Requirements />

- A Scaleway account logged into the [console](https://console.scaleway.com)
- [Owner](/iam/concepts/#owner) status or [IAM permissions](/iam/concepts/#permission) allowing you to perform actions in the intended Organization
- Created a [Data Warehouse deployment](/data-warehouse/how-to/create-deployment/) and [attached it to a Private Network](/data-warehouse/how-to/use-private-networks/)
- Created a [Windows Instance](/instances/how-to/create-an-instance/) in the Private Network
<Message type="note">
You must use a Windows Server version other than Core in order to have access to the GUI.
</Message>

## Installing a data gateway on the Windows Instance

Download and install [On-premises data gateway](https://www.microsoft.com/en-us/download/details.aspx?id=53127) on your Windows Instance.
If everything goes well, the following message displays:
`The gateway <gateway name> is online and ready to be used.`

## Configuring the ODBC data source

1. Download and install the latest [Clickhouse ODBC driver](https://github.com/ClickHouse/clickhouse-odbc/releases/).
    <Message type="note">
        Make sure to install the latest `powerbi-win64.msi` version.
    </Message>

2. From the Start Menu, open ODBC Data Sources (64-bit).

3. In the **Drivers** tab, make sure to view the following drivers:
    - ClickHouse ODBC driver (ANSI)
    - ClickHouse ODBC driver (Unicode)

4. Click **Add**, in the **System DSN** tab. A list of drivers displays.

5. Select **ClickHouse ODBC Driver (Unicode) from the list and click **Finish**. A creation wizard displays.

6. Enter the following values:
    - Name: The name you want to give to your new data source
    - Host: the private endpoint of your Data Warehouse deployment
    - Port: `8443`
    - Database: default or any database of your choice
    - User: A user with read permissions on the selected database
    - Password: The user's password
    - Check the **SQL Compatibility Settings** check box

7. Click **Ok** to create the data source.

## Installing the TLS certificate on the Windows Instance

1. From your Data Warehouse deployment page in the Scaleway console, download the TLS certificate for your deployment.

2. Right-click the TLS certificate file you just downloaded, then select **Install certificate**. An import wizard displays.
    1. Select **Local machine**, then click **Next**.
    2. Select **Place all certificates in the following store**, then click **Browse**.
    3. Select **Trusted Root Certification Authorities**, then click **Ok**.
    4. Click **Next**, then click **Finish**.

3. In **On-premises data gateway**, go to **Service Settings** to restart the application.

## Connecting PowerBI to your deployment

1. Log into [PowerBI Service](https://app.powerbi.com/) with the Microsoft account that you used to register the On-premises data gateway.
2. Click **New report**, then select **Get data**.
3. Select **ODBC** from the list. A connection wizard displays.
4. Enter the following values:

    - ODBC connection string: `dsn=<name_of_data_source_created_earlier>`
    - Connection: Create new connection
    - Connection name: The name you want to give to your connection
    - Data gateway: Your On-premises data gateway
    - Authentication kind: `Basic`
    - Username: The same username used in the System DSN previously created
    - Password: The user's password

5. Click **Next**.

Your Data Warehouse for ClickHouse® is now integrated into your PowerBI platform.

Refer to the official [ClickHouse®](https://clickhouse.com/docs/integrations/powerbi) and [PowerBI](https://learn.microsoft.com/en-us/power-query/connectors/clickhouse) documentation portals for more information.