Skip to main content

Configuring connections

There are two ways to enable the DAX Tabular dialect - global level (for all connections), and connection level.

Global Configuration​

AtScale's query engine can be configured to treat all incoming DAX requests as DAX Tabular requests. To enable this functionality for all DAX queries, set the xmla.discover.properties.daxdialect global setting to tabular, then restart the engine.

This setting also supports the following values:

  • legacy: Causes the system to support the SSAS 2012 dialect
  • superdaxmd: Causes the system to support the SuperDAX MD dialect; for details, see Using SuperDAX MD

Connection-Level Configuration​

When connecting to AtScale with Power BI Desktop, you can set a specific connection string parameter to enable workbook-specific DAX Tabular support. This will allow the AtScale engine to continue to service the legacy workbooks with the same installation:

  • The connection string parameter is daxdialect=tabular.
  • For example, you can set it like this: http://atscale.mycompany.com:10502/xmla/default?daxdialect=tabular

Make sure to set the connection parameter in the following places:

  • Each Power BI workbook that will use the DAX Tabular dialect.
  • Each Power BI Service Datasource configuration that will use the DAX Tabular dialect.

When connecting to AtScale with PowerBI Service, you must set the same query string parameter to the Server field of all desired Datasource configurations.

More information​

Using DAX Tabular