Client libraries for connecting to Azure Analysis Services

Client libraries are necessary for client applications and tools to connect to Analysis Services servers.

Analysis Services utilize three client libraries. ADOMD.NET and Analysis Services Management Objects (AMO), are managed client libraries. The Analysis Services OLE DB provider (MSOLAP DLL) is a native client library. Typically, all three are installed at the same time. Azure Analysis Services requires the latest versions.

Microsoft client applications such as Power BI Desktop and Excel install all three client libraries. However, depending on the version of Excel, or whether or not newer versions of Excel and Power BI Desktop are updated monthly, the client libraries installed may not be updated to the latest versions required by Azure Analysis Service. The same applies to custom applications or other interfaces such as AsCmd, TOM, ADOMD.NET. These applications require manually installing the libraries. The client libraries for manual installation are included in SQL Server feature packs as distributable packages; however, these are tied to the SQL Server version and may not be the latest.

Client libraries for client connections are different from data providers required to connect from an Azure Analysis Services server to a data source. To learn more about datasource connections, see Datasource connections.

Download the latest preview client libraries

Use the following client libraries to get the latest bug fixes and updates. These are recommended when connecting to Azure Analysis Services or SQL Server vNext Analysis Services.

MSOLAP (amd64) Preview
MSOLAP (x86) Preview
AMO Preview
ADOMD Preview

Download the latest RTM client libraries

Use the following client libraries if you are in a production environment and require fully released and supported versions.

MSOLAP (amd64)
MSOLAP (x86)

Next steps

Connect to an Azure Analysis Services server.