How to open your data connection in Excel

This guide shows you how to open the connection to your Azure or IDA cube in Excel if you have already made the connection.

Are you looking for a guide, that shows you how to connect to your POS cube?

See here how you make a connection to the IDA cube

See here how you make a connection to the Azure cube

 

This guide is based on Microsoft365.

Open your connection to Azure or IDA in Excel

1. In the tab list press Data and in the ribbon press Existing Connections.

Data Connection 1.0

 

2. In the pop-up window, select the connection from the list like shown and press Open.

Data Connection 2.0

 

3. In the next pop-up window, press OK to import data.

You are now ready to work with your data in the PivotTable.

Data Connection 3.0