Connect to Analysis Services

You can create a dynamic connection from an Excel workbook to an Analysis Services Database, then refresh that connection whenever the data is updated.

Note: The screen shots in this article were taken in Excel 2016. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same.

  1. Click on the Data tab, then Get Data > From Database > From Analysis Services. If you don't see the Get Data button, then click From Other Sources > From Analysis Services

  2. In the Data Connection Wizard, enter the Server name, and select a login option. Click Next.

    Data connection wizard > Connect to server
  3. Select the database and table or cube that you want to connect to, then click Next.

    Data connection wizard > Select database and table
  4. Enter a name and description for the new connection, and press Finish to save it.

    Data connection wizard > Save data connection file and finish
  5. In the Import Data dialog, select an option for how you want the data to be retrieved, and where you want to place the it. Beginning with Excel 2013, you also have the option to save the data to the Data Model.

    Data connection wizard > Import data

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Power Query is known as Get & Transform in Excel 2016

Import data from external data sources

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.