Configuring DAX Tabular Connections
You can enable the DAX Tabular dialect at either the global level (for all connections), or the connection level (for specific connections only).
Configure the DAX Tabular dialect for all connections
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.
Configure the DAX Tabular dialect for specific connections
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.