Microsoft’s Power BI is a suite of data visualization and business analytic tools. It offers tools to easily analyze, transform and visualize data pipelines, including the ability to build reusable models. The software enables users to integrate their apps, so as to deliver reports along with real-time dashboards. Providing a user-friendly interface and excellent data visualization capabilities, users can choose from the Pro plan or a more limited free version.
Creates a single data model from different types of data sources
Good data visualization capabilities
As part of Microsoft business suite, linked to other tools as Excel and SQL Server
Credentials and Connection Details
You need the following information to connect Power BI:
Download and install the latest version of ODBC driver for Clickhouse from Clickhouse GitHub (you can find latest version of ClickHouse ODBC driver here).
Run ODBC Data Sources tool and configure connection with ClickHouse. If you downloaded the 64-bit Clickhouse driver previously, then you need to open ODBC Data Sources (64-bit).
IMPORTANT: Make sure that Clickhouse drivers are available (use the Unicode one).
Create a new System DSN, using the ClickHouse ODBC Driver (Unicode)
Fill in your credentials (if you work with large tables you might need to increase the default Timeout from 30s to 60-300s depending on the size of your table) and click “Ok“ to save the new System DSN connection.
Run Power BI Desktop App → Get Data → select ODBC source → Select the Data Source Name created on the previous step.
You will see the list of available databases and tables associated with them.
IMPORTANT: be sure to use tables with the _all_data suffix in your reports.