Power View and OLAP in Excel 2016

In Excel 2016, you can connect to OLAP cubes (often called multidimensional cubes) and create interesting and compelling report pages with Power View.

To connect to a multidimensional data source, from the ribbon select Data > Get External Data > From Other Sources > From Analysis Services.

Connect to Analysis Services

In the Data Connection Wizard, type the server name where the cube is hosted, then select and provide the appropriate credentials.

Connect to Database Server

Excel presents a dialog that lists the databases, tables, and cubes that are available from the server.

Select Cube

Once you select the cube you’re interested in using and select Next, you can choose where you want to view the connected data in your workbook. In this case you want to create a Power View report, so select the radio button next to Power View Report.

Send to Power View Report

In the Power View Fields pane, you can see and access the available fields from the cube.

Power View Fields pane populated

Now you’re ready to use the data from the cube to create compelling reports. You may find many different types of data, including the following:

Measure groups – this is the collection of measures found in the cube.

Measure groups

Measures and KPIs within a measure group – you can also use individual measures and KPIs from within measure groups. Just expand a measure group to see the available elements within a measure group, as shown in the following screen.

Measures and KPIs within a measure group

Dimensions, attributes and hierarchies – you can also use other fields from the cube, just like you would use in any other report.

Dimensions, attributes and hierarchies

With all those available fields, you can create interesting, interactive reports with Power View and OLAP cubes.

Power View report with OLAP data

Additional Resources

For more information about Power View, OLAP, or Analysis Services, take a look at the following links:

Power View - Overview and Learning

Power View: Explore, visualize, and present your data

Power View and Power Pivot videos

Get data from Analysis Services

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×