Microsoft Power BI
Microsoft Power BI (opens in a new tab) is a popular business intelligence tool.
Cube Cloud works with both Power BI Desktop and Power BI service (opens in a new tab). If you're using Power BI service, you need to set up an on-premises data gateway (opens in a new tab).
Connect from Cube Cloud
Cube Cloud provides the DAX API to connect to Power BI.
Navigate to the Integrations page, click Connect to Cube, and choose Microsoft Power BI to get detailed instructions.
Previously, Semantic Layer Sync was recommended as a way to connect to Power BI. Since the introduction of the DAX API, it's now the preferred method.
Connect from Cube Core
You can connect a Cube deployment to Power BI using the SQL API. However, it would not provide the same experience as the DAX 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
DAX API
In Power BI, choose the SQL Server Analysis Services database option when connecting to a data source. The, enter the credentials.
To find your DAX API credentials, go to the Integrations page, click API credentials, and choose the DAX API tab.
It's not recommended to import data into Power BI when connecting to Cube. Use a live connection whenever possible. Read more about pros and cons of these methods.
SQL API
Power BI can also connect to Cube as to a Postgres database.