Connect to a SQL Server Analysis Services Database (Import)

Use Excel's Get & Transform (Power Query) experience to connect to a SQL Server Analysis Services (OLAP) database server. You can import data into Excel and refresh the connection when the source data changes.

1. Select the Data tab, and then select Get Data > From Database > From SQL Server Analysis Services Database (Import).

2. Enter the Server name and select OK.

   Note

   You can enter a specific database name, and you can add an MDX or DAX query.

3. In the Navigator pane, select the database, and then select the cube or tables you want to connect to.

4. Select Load to load the selected data, or select Transform Data to perform additional data filters and transformations before loading it.

See also

About Power Query in Excel

Import data from external data sources