Enable this property to pass MDX queries directly to Microsoft Power BI XMLA. When disabled, the provider translates SQL-92 queries into operations on the modeled views.

Data Type

bool

Default Value

false

Remarks

This property determines whether the connector processes SQL-92 queries or passes MDX queries directly to Microsoft Power BI XMLA. By default, the driver allows SQL-92 SELECT queries to interact with views modeled by the driver. When you enable this property, the driver bypasses the SQL translation layer and sends MDX queries as-is to the XMLA endpoint.

This property is useful for advanced users familiar with MDX who need direct access to multidimensional queries for more granular or complex operations.