Microsoft Excel

Microsoft Excel is a popular spreadsheet application.

Microsoft Excel is a popular spreadsheet application.

Connect from Cube Cloud

Cube Cloud provides two options to connect to Excel:

	MDX API	Cube Cloud for Excel
Operating systems	Microsoft Windows	All, including macOS
Platforms	Desktop	All, including web and mobile
Pivot table support	Native PivotTable	Custom pivot table UI

Navigate to the Integrations page, click Connect to Cube, and choose Microsoft Excel to get detailed instructions.

Connect from Cube Core

There’s no way to connect a Cube Core deployment to Excel.

Connect from Microsoft Excel

MDX API

In Excel, go to the Data tab of the ribbon, click Get Data and select From Database → From Analysis Services. Then, enter the credentials.

To find your MDX API credentials, go to the Integrations page, click API credentials, and choose the MDX API tab. Use the full MDX API URL, including the /cubejs-api/v2/mdx path, as the server name.

The MDX API supports Kerberos and NTLM authentication, configured on the Settings → Power BI page of your deployment.

Cube Cloud for Excel

Follow the instructions to install the add-in and authenticate to Cube Cloud.