> ## Documentation Index
> Fetch the complete documentation index at: https://cubed3-feat-druid-driver-streaming.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.

While NTLM can be used for testing purposes, we strongly recommend configuring
Kerberos for production environments.

## 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/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