Connect to SSAS on Azure VM from Excel PivotTable

By - Updated April 10, 2019

To allow a PivotTable to connect to the SSAS database on an 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 into Azure Portal, select the 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 into the VM, open Windows Firewall, and open port 2383 in Inbound Rules.

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