Connect from Cube Cloud
Cube Cloud provides two options to connect to Excel:
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 the same Kerberos and NTLM
authentication methods as the DAX API, configured on the Settings → Power BI page
of your deployment.