Skip to main content
DAX API The DAX API enables Cube to connect to Microsoft Power BI. It derives its name from data analysis expressions, a query language for Power BI and SQL Server Analysis Services. Unlike the SQL API, it provides a native experience and superior support for Power BI features.
Available on Enterprise plan.
Read below about the DAX API configuration, authentication, and using it with Power BI. See the DAX API reference for the list of supported DAX functions.

​
Configuration

Please contact the customer success team in Cube Cloud so we can guide you through the configuration.
To enable or disable the DAX API on a specific deployment, go to Settings in the Cube Cloud sidebar, then Configuration, and then toggle the Enable DAX API option.

​
Date hierarchies

By default, the DAX API exposes all time dimensions as date hierarchies in Power BI. You can set the CUBEJS_DAX_CREATE_DATE_HIERARCHIES environment variable to false to disable this behavior. Note that each date hierarchy will include additional columns, suffixed by _year, _quarter, _month, _day. If the data model has other members with names that follow this pattern (e.g., a time dimension named date and another dimension named date_year in the same cube or view), that would cause a conflict.

​
Authentication

The DAX API supports Kerberos and NTLM authentication methods, as well as user name and password authentication. While NTLM can be used for testing purposes, we strongly recommend configuring Kerberos for production environments. Authentication is configured on the Settings → Power BI page of your deployment. It shows the XMLA endpoint URL and manages the XMLA service account credentials and the Kerberos setup, including the keytab upload. For quick connectivity tests, you can also enable short-lived token authentication in Settings → Configuration; it is not recommended for production.

​
Data modeling

The DAX API only exposes views, not cubes.

​
Cross-view filtering

By default, each view is exposed as a separate perspective in Power BI, so visualizations from different views can’t share the same filters. Cross-view filtering lets you build dashboards that span multiple views and apply filters consistently across visualizations. See Cross-view filtering for details on how to enable and use it.