Connect to SSAS on Azure VM from Excel PivotTable

By - Mar 14, 2018

To allow PivotTable to connect to the SSAS database resides on Azure VM, we will first need to turn on the SSAS port on the machine. Please note, only Windows AD and Azure AD Integrated authentication mode supports direct connection to SSAS.

First, log in to Azure Portal, select Virtual Machine icon on the left navigation pane, select the VM you are working on, click Endpoints, and click Add.

The default port for SQL Analysis Services is 2383.  Create the endpoint as follows.

Then, log in to the VM, open Windows Firewall, and open port 2383 in Inbound Rules.

Now you can configure connect to the SSAS database on Azure VM from Excel on your own laptop.