Before you start working with spreadsheets in the Veeam VMware PowerPivot Example workbook, connect to your Ops Mgr 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.|
|4.||In the Edit Connection window, expand the Server name drop-down list and choose your server which hosts Data Warehouse.|
Click Test Connection, wait for the connection to be tested, click OK and then click Save.
|5.||On the Home tab, click Refresh > Refresh All, wait for the new data to be retrieved and click Close.|
|6.||Close the PowerPivot For Excel window.|