Before you start working with spreadsheets in the Veeam VMware
PowerPivot Example workbook, connect to your Ops Mgr DW to retrieve
data from it:
Excel, open the PowerPivot tab
and click Manage.
Excel window, switch to the
tab and click Existing Connections.
Connections window, select the
data source and click Edit.
Connection window, expand the
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.
tab, click Refresh > Refresh All,
wait for the new data to be retrieved and click Close.