1. Home
  2. Other Resources
  3. FAQ
  4. Connect Data Cube with PowerBI or Excel

Connect Data Cube with PowerBI or Excel

Open PowerBI, click Get Data, select category Azure and choose “Azure Analysis Service database”

PowerBI connection screen

Click Connect.

Enter the server URL: asazure://westeurope.asazure.windows.net/survalyzeranalysiseu

server connection string

Click Ok.

Click on “Microsoft Account” and “Sign in”

sign in screen

The regular SSO page is shown, click on your user and login.

Click on Save to finalize the setup.

confirmation screen

Select the cube which shall be queried.

cube selection

Click Ok.

The login procedure needs to be done only once. The connection is persisted in PowerBI in an encrypted form.

Updated on July 29, 2022

Was this article helpful?

Related Articles

Need Support?
Please login to your Survalyzer account and use the "Create Support Request" form.
Login to Survalyzer