Configuring connections
There are two ways to enable the DAX Tabular dialect - engine level (for all connections), and connection level.
Engine-Level 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:
-
In the Design Center, go to Settings > Engine.
-
Locate the the
xmla.discover.properties.daxdialectengine setting, and set its value totabular.It can also have 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
-
Restart the engine as described in Changing Engine Settings.
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.