PowerBI

⚠️Power BI support is in preview

Power BI support is in preview, not all features and requests may work at this point.

You can connect to Cube from Power BI, interactive data visualization software product developed by Microsoft, using the Cube SQL API.

Enable Cube SQL API

Don't have a Cube project yet? Learn how to get started here.

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=mypassword

Connecting from Power BI

Power BI connects to Cube as to a Postgres database.

Querying data

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

Observable Retool