How to connect your deployment to PowerBI in a Private Network

Reviewed on March 11, 2026

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.

Open Image over content

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization
• Created a Data Warehouse deployment and attached it to a Private Network
• Created a Windows Instance in the Private Network

Installing a data gateway on the Windows Instance

Download and install On-premises data gateway 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.

   Note

   Make sure to install the latest powerbi-win64.msi version.

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 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® and PowerBI documentation portals for more information.