The query language used to translate SQL queries when interacting with Microsoft SQL Server Analysis Services. Select MDX or DAX to determine the query mode used.

Possible Values

Data Type

string

Default Value

"MDX"

Remarks

This property controls whether the provider translates SQL queries into MDX (Multidimensional Expressions) or DAX (Data Analysis Expressions) when executing queries against Microsoft SQL Server Analysis Services.

Available values are:

• MDX (default) - Uses MDX for query translation. MDX is compatible with both multidimensional and tabular models and is the traditional query language for OLAP cubes. The data model exposes dimensions, hierarchies, and levels as views.
• DAX - Uses DAX for query translation. DAX is optimized for tabular data models and provides simpler data type mapping, more natural aggregation support, and improved JOIN handling. The data model exposes tables and columns directly from the tabular model.

Interaction with QueryPassthrough

The QueryPassthrough property can be used for query passthrough regardless of this setting. When QueryPassthrough is true, raw queries (MDX or DAX) are sent directly to Microsoft SQL Server Analysis Services without SQL translation.