XML for Analysis (XMLA) Compliance
Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium
The XML for Analysis 1.1 specification describes an open standard that supports data access to data sources that reside on the World Wide Web. This article details the level of compliance with the XML for Analysis 1.1 specification supported by all Analysis Services platforms: Azure Analysis Services, SQL Server Analysis Services, and Power BI Premium.
Compliant items
Analysis Services complies with all mandatory items listed in the XML for Analysis 1.1 specification. In addition, Analysis Services implements the following optional item described in the XML for Analysis 1.1 specification.
Item | Specification | Implementation |
---|---|---|
Session support | The SOAP header elements listed in "Support for Statefulness in XML for Analysis" section of the XML for Analysis 1.1 specification. | All listed SOAP header elements are supported by Analysis Services, as described within the specification. |
Extensions
Analysis Services also extends the XML for Analysis 1.1 specification to support the following additional features and capabilities.
Item | Specification | Implementation |
---|---|---|
Protocol negotiation | No information contained in the XML for Analysis 1.1 specification | ProtocolCapabilities header element added by Analysis Services to support negotiation of protocol capabilities. |
XML for Analysis (XMLA) commands supported by the Discover method | The following commands are supported by the XML for Analysis 1.1 specification: Statement Element (XMLA) |
The following commands are supported by Analysis Services: Alter Element (XMLA) Backup Element (XMLA) Batch Element (XMLA) BeginTransaction Element (XMLA) Cancel Element (XMLA) ClearCache Element (XMLA) CommitTransaction Element (XMLA) Create Element (XMLA) Delete Element (XMLA) DesignAggregations Element (XMLA) Drop Element (XMLA) Insert Element (XMLA) Lock Element (XMLA) MergePartitions Element (XMLA) NotifyTableChange Element (XMLA) Process Element (XMLA) Restore Element (XMLA) RollbackTransaction Element (XMLA) Statement Element (XMLA) Subscribe Element (XMLA) Synchronize Element (XMLA) Unlock Element (XMLA) Update Element (XMLA) UpdateCells Element (XMLA) |
Column errors in tabular rowsets | Not listed in XML for Analysis 1.1 specification. | The Error element is used by Analysis Services to report errors for column elements contained in a row element. |