View Administrative Reports (PowerPivot for SharePoint)

PowerPivot Management Dashboard is a collection of predefined reports and web parts in SharePoint Central Administration that help you administer a SQL Server PowerPivot for SharePoint deployment.

How you open a PowerPivot Management dashboard determines the view you work with. If you open it from the service application, you will only see the operational data that applies to that PowerPivot service application, even if you are an administrator of other PowerPivot service applications in the farm.

To open a dashboard with the ability to switch service applications

  1. In Central Administration, in General Application Settings in the PowerPivot section, click Management Dashboard.

  2. On the main page, select the PowerPivot service application for which you want to view operations data. The dashboard only shows information for one PowerPivot service application at a time.

To open a dashboard view into a single service application

  1. In Central Administration, in Application Management, click Manage service applications.

  2. Click the PowerPivot service application link. The PowerPivot Management Dashboard displays operational data for the current service application only, with no ability to switch to another application.

Refreshing PowerPivot Server Health and Usage Data

The built-in administrative reports use an internal PowerPivot workbook as a data source. This workbook is refreshed through timer jobs that move usage and health data to different storage locations in the SharePoint farm. The workbook is refreshed on a fixed schedule that runs daily.

Configuring a custom data refresh schedule for the built-in reports is not supported. Attempting to configure a data refresh schedule for the built-in reports results in the following error:

"SQL Server Analysis Services (PowerPivot) instance returned the following error: Error Code: 3241607174 Description: A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook, file 'C:\Program Files\Microsoft SQL Server\MSAS10_50.POWERPIVOT\OLAP\Backup\Sandboxes\Default PowerPivot Service Application\ReadOnlyExclusive-96b00523-45df-4ef0-b194-8f6d7ceb0f92-Server Health.xlsx'."

An alternative approach to configuring data refresh is to run the timer jobs manually. Typically, these jobs run once a day, but you can use the Run Now command to force data refresh of the server health and usage data that appears in the administrative reports. For more information, see Configure Usage Data Collection (PowerPivot for SharePoint).