Power BI

The Power BI tile on the Universe page downloads a Power BI project template that reads your DataMind OS data. Pick Native to query tables through Power BI's ClickHouse connector, or ODBC to run your own SQL through the ClickHouse ODBC driver. You supply your server's host and port, and each person signs in with their own account.

Choose Native or ODBC

Template	How Power BI reads your data	What you replace first
Native	DirectQuery through Power BI's ClickHouse connector: the report queries the server as you use it.	The sample table.
ODBC	Import: the query result is loaded into the report. Needs the ClickHouse ODBC driver and a ClickHouse ODBC data source on your computer.	The sample query.

Pick Native for live tables. Pick ODBC when you want to write your own SQL. To build reports inside DataMind OS instead, see DataPrism.

Before you start

A computer with Power BI Desktop.
Your DataMind OS email and password. Power BI asks for them when it connects.
For ODBC only: the ClickHouse ODBC driver installed, and a ClickHouse ODBC data source created. DataMind OS does not install or create either for you.

Important

Install the driver and create the data source before you open the ODBC template. Power BI cannot run the sample query without them.

Download and open the template

In the sidebar, open Universe and find the Integrations block.
On the Power BI tile, click Native or ODBC. The template downloads as a zip file, and a Download successful message confirms the download.
Unzip the file, then open the Power BI project (.pbip) file in Power BI Desktop.
Set the template's parameters from Connection Settings: HOST and PORT for both templates, and SSL for ODBC. The settings below list them.
When Power BI asks for credentials, sign in with your DataMind OS email and password.
Replace the sample content before you build reports:
- Native: remove the sample table and add the tables you want to report on.
- ODBC: replace the sample query with your own SQL.

Settings

Both templates use HOST and PORT; the ODBC template uses SSL as well. Take the values from Connection settings.

Parameter	What to enter
HOST	The Host from Connection Settings.
PORT	The Port from Connection Settings.
SSL	1 when your server uses an encrypted (HTTPS) address, otherwise 0. The default is 0.

Access

Every signed-in user can download both templates.
Power BI shows the data your roles allow, the same as in the Editor. See SQL dialect and data scope.
Power BI signs in with your DataMind OS email and password. If you change your password, use the new one the next time you sign in from Power BI.

Limits and edge cases

Set the template up from a computer. Universe does not open on a phone.
Open the project (.pbip) with a Power BI Desktop version that supports Power BI project files.
A failed download shows Download failed with the reason. See Troubleshooting integrations.

Questions, answered

Native or ODBC, which do I pick?

Pick Native when you want tables that query the server live through Power BI's ClickHouse connector. Pick ODBC when you want to write your own SQL query and can install the ODBC driver on your computer.

What do I enter for HOST and PORT?

The Host and Port values from Connection settings, the same values any desktop tool uses.

What do I enter for SSL in the ODBC template?

1 when your server uses an encrypted (HTTPS) address, otherwise 0, which is the default. Connection Settings does not show whether your server uses encryption, so ask your administrator if you are not sure.

Which credentials does Power BI need?

Your DataMind OS email and password. If you sign in with single sign-on and have no password yet, set one first: see Connection settings for how.

Do I need to install anything to use Power BI with DataMind OS?

Native uses the ClickHouse connector built into Power BI. ODBC needs the ClickHouse ODBC driver and a ClickHouse ODBC data source on your computer; you install and create them yourself.

Why does the Native report not show my data?

The template starts with a sample table as a placeholder. Remove it and add the tables you want to report on.

Why does the ODBC template return only one row?

The template starts with a sample query as a placeholder, which returns a single row. Replace it with your own SQL.

Do I unzip the download before I open it?

Yes. The zip holds the Power BI project folder. Unzip it, then open the project (.pbip) file inside the folder in Power BI Desktop.

Is the template personal?

No. Everyone downloads the same template. It holds no email and no password, so each person signs in with their own DataMind OS account.