PowerBI

How to configure PowerBI

This guide walks you through connecting ClickHouse to Power BI Desktop using the ODBC driver. It covers driver installation, ODBC configuration, Power BI integration, and setting up data refresh.

1. Install the ClickHouse ODBC Driver

2. Configure the ODBC Data Source

  • Open ODBC Data Source Administrator (64-bit) via Control Panel or Windows Search.

  • Go to the System DSN tab and click Add.

  • Select ClickHouse ODBC Driver from the list and click Finish.

  • Fill in the required fields. You can find the necessary information in:

    DocBitsSettingsDocument ProcessingModuleAI DashboardClickHouse Direct Access

    Required Fields:

    • Name: A name for the connection (e.g., ClickHouse_Prod)

    • Description: A short description for your reference (optional)

    • Host: Copy the host value from DocBits

    • Port: Copy the port value from DocBits

    • Database: Copy the database name from DocBits

    • Username: Copy the username from DocBits

    • Password: Copy the password from DocBits

3. Connect ClickHouse to Power BI

  • Open Power BI Desktop.

  • Select Get DataODBCConnect.

  • From the DSN list, select your configured source (e.g., ClickHouse_Prod).

  • Click OK. Enter credentials again if prompted.

4. Load and Transform Data

  • In the Navigator pane, browse and select the tables or views to import.

  • Choose:

    • Load: to import directly

    • Transform Data: to open Power Query for data shaping

5. Visualize Your Data

  • Use the report canvas to build visualizations.

  • Drag fields, add slicers, choose chart types, and use DAX expressions as needed.

  • Leverage Power Query Editor to clean or pivot your ClickHouse data before building visuals.

6. Enable Scheduled Refresh (Optional)

Note: Requires Power BI Pro or Premium + Gateway

  • To keep your reports in sync with ClickHouse:

  • Publish your .pbix file to Power BI Service.

  • Install the Power BI Gateway (Standard mode) on a machine with network access to ClickHouse.

  • In Power BI Service:

    • Go to your dataset → SettingsScheduled Refresh

    • Map your DSN and provide credentials

  • More informations here.

7. Example Dashboards & Data Views

Last updated

Was this helpful?