Connect to SSAS Cube on Azure VM from Excel PivotTable

Author: Serena Wang

Introduction

It's possible to connect a PivotTable to the SSAS database on an Azure VM.

Example

To do so, 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 connection to the SSAS database on an Azure VM from Excel on your own laptop.