| title | description | author | manager | ms.service | ms.topic | ms.date | ms.author | ms.reviewer |
|---|---|---|---|---|---|---|---|---|
Connecting to Azure Analysis Services servers| Microsoft Docs |
Learn how to connect to and get data from an Analysis Services server in Azure. |
minewiskan |
kfile |
azure-analysis-services |
conceptual |
10/18/2018 |
owend |
minewiskan |
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.
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 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.
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.
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.
When connecting to Azure Analysis Services using the Tabular Object Model, use the following connection string formats:
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>;"
"Provider=MSOLAP;Data Source=<Azure AS instance name>;User ID=<user name>;Password=<password>;Persist Security Info=True; Impersonation Level=Impersonate;";
Use the Windows account running the current process.
"Provider=MSOLAP;Data Source=<Azure AS instance name>; Integrated Security=SSPI;Persist Security Info=True;"
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.