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.
SQL API
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.
CUBEJS_PG_SQL_PORT=5432
CUBEJS_SQL_USER=myusername
CUBEJS_SQL_PASSWORD=mypasswordConnecting 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.