Connecting to servers

This article describes connecting to a server by using data modeling and management applications like SQL Server Management Studio (SSMS) or SQL Server Data Tools (SSDT). Or, with client reporting applications like Microsoft Excel, Power BI Desktop, or custom applications. Connections to Azure Analysis Services use HTTPS.

Client libraries

Get the latest Client libraries

All connections to a server, regardless of type, require updated AMO, ADOMD.NET, and OLEDB client libraries to connect to and interface with an Analysis Services server. For SSMS, SSDT, Excel 2016 and later, and Power BI, the latest client libraries are installed or updated with monthly releases. However, in some cases, it's possible an application may not have the latest. For example, when policies delay updates, or Office 365 updates are on the Deferred Channel.

Server name

When you create an Analysis Services server in Azure, you specify a unique name and the region where the server is to be created. When specifying the server name in a connection, the server naming scheme is:

<protocol>://<region>/<servername>

Where protocol is string asazure, region is the Uri where the server was created (for example, westus.asazure.windows.net) and servername is the name of your unique server within the region.

Get the server name

In Azure portal > server > Overview > Server name, copy the entire server name. If other users in your organization are connecting to this server too, you can share this server name with them. When specifying a server name, the entire path must be used.

Get server name in Azure

Note

The protocol for East US 2 region is aspaaseastus2.

Connection string

When connecting to Azure Analysis Services using the Tabular Object Model, use the following connection string formats:

Integrated Azure Active Directory authentication

Integrated authentication picks up the Azure Active Directory credential cache if available. If not, the Azure login window is shown.

"Provider=MSOLAP;Data Source=<Azure AS instance name>;"
Azure Active Directory authentication with username and password
"Provider=MSOLAP;Data Source=<Azure AS instance name>;User ID=<user name>;Password=<password>;Persist Security Info=True; Impersonation Level=Impersonate;";
Windows authentication (Integrated security)

Use the Windows account running the current process.

"Provider=MSOLAP;Data Source=<Azure AS instance name>; Integrated Security=SSPI;Persist Security Info=True;"

Connect using an .odc file

With older versions of Excel, users can connect to an Azure Analysis Services server by using an Office Data Connection (.odc) file. To learn more, see Create an Office Data Connection (.odc) file.

Next steps

Connect with Excel
Connect with Power BI
Manage your server