Applies to:
SQL Server Analysis Services
Azure Analysis Services
Fabric/Power BI Premium
ADOMD.NET is a Microsoft .NET Framework data provider designed to communicate with Analysis Services. ADOMD.NET uses the XML for Analysis protocol to communicate with analytical data sources by using either TCP/IP or HTTP connections to transmit and receive SOAP requests and responses that are compliant with the XML for Analysis specification. Commands can be sent in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), Analysis Services Scripting Language (ASSL), or even a limited syntax of SQL, and may not return a result. Analytical data, key performance indicators (KPIs), and mining models can be queried and manipulated by using the ADOMD.NET object model. By using ADOMD.NET, you can also view and work with metadata either by retrieving OLE DB-compliant schema rowsets or by using the ADOMD.NET object model.
The ADOMD.NET data provider is represented by the Microsoft.AnalysisServices.AdomdClient namespace.
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
The ADOMD.NET client components provide the functionality for client and middle-tier applications to easily query data and metadata from an analytical data store.
Learn how to use the AdomdConnection object in ADOMD.NET to open connections with analytical data sources, such as Microsoft SQL Server Analysis Services databases.