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:
Connect from Cube Cloud
It is recommended to use Semantic Layer Sync to connect Cube Cloud to Power BI. It automatically synchronizes the data model with Power BI.
Navigate to the Integrations page, click Connect to Cube, and choose Microsoft Power BI to get detailed instructions.
Connect from Cube Core
You can connect a Cube deployment to Power BI using the SQL API.
In Cube Core, the SQL API is disabled by default. Enable it and configure the credentials to connect to Power BI.
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.