Power BI

Power BI (opens in a new tab) is an interactive data visualization software product developed by Microsoft.

See how you can use ksqlDB and Cube Cloud to power real-time analytics in Power BI:

Semantic Layer Sync

It is recommended to use Semantic Layer Sync to connect Cube to Power BI. It automatically synchronizes the data model between Cube and Power BI.


You can also use the SQL API to connect Cube to Tableau.

Cube Cloud

Click How to connect your BI tool link on the Overview page, navigate to the SQL API tab and enable it. Once enabled, you should see the screen like the one below with your connection credentials:

Self-hosted Cube

You need to set the following environment variables to enable the Cube SQL API. These credentials will be required to connect to Cube from PowerBI later.


Connecting from Power BI

Power BI connects to Cube as to a Postgres database using the DirectQuery (opens in a new tab) connectivity mode.

It's not recommended to import data into Power BI when connecting to Cube; choose DirectQuery instead. Use pre-aggregations to improve querying performance and manage data freshness upstream of Power BI.

Querying data

Your cubes will be exposed as tables, where both your measures and dimensions are columns.