Power BI

This guide provides step-by-step instructions for connecting Microsoft Power BI to Unistream.

Prerequisites

You will need:

• Microsoft Power BI Desktop installed on your computer (recommended to install via Microsoft Store)

• ClickHouse ODBC driver

• Unistream platform credentials (email and password)

Installation Steps

1. Install ClickHouse ODBC Driver

1. Download the ClickHouse ODBC driver from the official GitHub repository: https://github.com/ClickHouse/clickhouse-odbc/releases

2. If Windows is preventing you from running the .msi file:

   • Unzip the zip file

   • Right-click on the .msi file → Properties

   • At the bottom of the Properties window, check the "Unblock" checkbox

   • Click "Apply" then "OK"

   • Now you can run the installer

3. Install the driver by following the installation wizard instructions

2. Download Connection Files from Unistream

In Unistream's Integration Hub, you will find two download options:

1. Direct Query & Import Objects (tables, views)

   • Uses native ClickHouse connection (still requires ODBC driver)

2. Import Mode Custom SQL

   • Uses ODBC connection

   • Allows you to provide custom SQL queries

3. Connect to Unistream

1. Unzip the downloaded folder for your preferred connection method

2. Open the .pbip file with Power BI Desktop

3. When prompted for authentication (if not prompted, click "Refresh" in Power BI Desktop):

   • Enter your username (email)

   • Enter your password

4. You are now connected to Unistream

Additional Features

For instructions on how to:

• Toggle between connection modes

• Import multiple tables

• Change custom SQL queries

Please refer to our video tutorial below.

Video Tutorial

For a visual walkthrough, watch our tutorial video: