Step 1. Connect to the OpsMgr Data Warehouse

Before you start working with spreadsheets in the Veeam VMware PowerPivot Example workbook, connect to your OpsMgr DW to retrieve data from it:

  1. Launch Microsoft Excel, open the PowerPivot tab and click Manage.
  2. In the PowerPivot For Excel window, switch to the Home tab and click Existing Connections.
  3. In the Existing Connections window, select the SCOM_DW data source and click Edit.

Choose a data source

  1. In the Edit Connection window, expand the Server name drop-down list and choose your server which hosts Data Warehouse.

Choose a DW server

Click Test Connection, wait for the connection to be tested, click OK and then click Save.

Test the connection

  1. On the Home tab, click Refresh > Refresh All, wait for the new data to be retrieved and click Close.

Retrieve data

  1. Close the PowerPivot For Excel window.