| title | description | author | ms.service | ms.topic | ms.date | ms.author | ms.reviewer |
|---|---|---|---|---|---|---|---|
Connect to Azure Analysis Services with Excel | Microsoft Docs |
Learn how to connect to an Azure Analysis Services server by using Excel. Once connected, users can create PivotTables to explore data. |
minewiskan |
azure-analysis-services |
conceptual |
05/16/2022 |
owend |
minewiskan |
Once you've created a server and deployed a tabular model to it, clients can connect and begin exploring data. This article describes connecting to an Azure Analysis Services resource by using the Excel desktop app. Connecting to an Azure Analysis Services resource is not supported in Excel for the web.
The account you sign in with must belong to a model database role with at least read permissions. To learn more, see Authentication and user permissions.
Connecting to a server in Excel is supported by using Get Data in Excel 2016 and later. Connecting by using the Import Table Wizard in Power Pivot is not supported.
-
In Excel, on the Data ribbon, click Get Data > From Database > From Analysis Services.
-
In the Data Connection Wizard, in Server name, enter the server name including protocol and URI. For example, asazure://westcentralus.asazure.windows.net/advworks. Then, in Logon credentials, select Use the following User Name and Password, and then type the organizational user name, for example nancy@adventureworks.com, and password.
[!IMPORTANT] If you sign in with a Microsoft Account, Live ID, Yahoo, Gmail, etc., or you are required to sign in with multi-factor authentication, leave the password field blank. You are prompted for a password after clicking Next.
-
In Select Database and Table, select the database and model or perspective, and then click Finish.
