> ## Documentation Index
> Fetch the complete documentation index at: https://cubed3-igor-cub-2478-table-docs-reconcile.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# DAX API

> Connect Microsoft Power BI to Cube natively using the DAX API for superior feature support over the SQL API.

DAX API

The DAX API enables Cube to connect to [Microsoft Power BI][ref-powerbi].
It derives its name from [data analysis expressions][link-dax], a query language
for Power BI and SQL Server Analysis Services.

Unlike the [SQL API][ref-sql-api], it provides a native experience and superior
support for Power BI features.

<Note>
  Available on [Enterprise plan](https://cube.dev/pricing).
</Note>

Read below about the DAX API [configuration](#configuration),
[authentication](#authentication), and using it with Power BI.

See the [DAX API reference][ref-ref-dax-api] for the list of supported DAX functions.

<iframe width="100%" height="400" src="https://www.youtube.com/embed/vgrFPOMuJJs" title="YouTube video" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />

## Configuration

<Warning>
  Please contact the customer success team in Cube Cloud so we can guide you
  through the configuration.
</Warning>

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][ref-time-dimensions] as *date
hierarchies* in [Power BI][ref-power-bi]. You can set the [`CUBEJS_DAX_CREATE_DATE_HIERARCHIES`](/reference/configuration/environment-variables#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][ref-kerberos] and [NTLM][ref-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

<Info>
  The DAX API only exposes [views][ref-views], not cubes.
</Info>

## 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][ref-cross-view-filter] for details on how to enable
and use it.

[ref-powerbi]: /admin/connect-to-data/visualization-tools/powerbi

[ref-cross-view-filter]: /reference/core-data-apis/dax-api/cross-view-filter

[link-dax]: https://learn.microsoft.com/en-us/dax/

[ref-sql-api]: /reference/core-data-apis/sql-api

[ref-ref-dax-api]: /reference/core-data-apis/dax-api/reference

[ref-views]: /docs/data-modeling/views

[ref-time-dimensions]: /docs/data-modeling/dimensions#time-dimensions

[ref-kerberos]: /docs/integrations/power-bi/kerberos

[ref-ntlm]: /docs/integrations/power-bi/ntlm

[ref-power-bi]: /admin/connect-to-data/visualization-tools/powerbi