When querying a tabular model in DirectQuery mode, Analysis Services converts DAX formulas and measure definitions into SQL statements. For measures, DAX formulas are converted to set-based operations against the relational data store. This means that all measures created implicitly are supported.. GeoPITS brings you the comprehensive details of Direct query SQL Server Analysis Services's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes | ||
| Version v2017 | |||||
| Version v2016 | |||||
| Version v2014 | |||||
| Version v2012 |
When querying a tabular model in DirectQuery mode, Analysis Services converts DAX formulas and measure definitions into SQL statements. For measures, DAX formulas are converted to set-based operations against the relational data store. This means that all measures created implicitly are supported.
You can find more details about this version here
Back to all features