View Data Refresh History (Power Pivot for SharePoint)


Applies To: SQL Server 2016

Data refresh history is a record of all data refresh activity for Power Pivot data in an Excel workbook. Data refresh operations are performed on an Analysis Services server instance in a SharePoint farm on a schedule that you provide. By default, data refresh history is retained for one year. However, a farm administrator can specify a different retention policy for usage and event history that determines how long data refresh records are kept.

Applies to: SharePoint 2013 | SharePoint 2010

In this topic:


View Data Refresh History for an Individual Workbook

View Data Refresh History for All Workbooks

Use History Information

You must have Contribute permissions or greater to view the data refresh history.

You must have enabled and scheduled data refresh on a workbook that contains Power Pivot data. If you have not scheduled data refresh, you will see the schedule definition page instead of history information.

  1. On a SharePoint site, open the library that contains an Excel workbook that contains Power Pivot data.

    There is no visual indicator that identifies which workbooks in a SharePoint library contain Power Pivot data. You must know in advance which workbook contains refreshable Power Pivot data.

  2. Select the workbook, and then click the down arrow that appears to the right.

  3. Select Manage Power Pivot Data Refresh.

The history page appears, showing a complete record for all refresh activity for Power Pivot data in the current Excel workbook.

Using the Power Pivot Management Dashboard in Central administration, farm administrators and service application administrators can get a comprehensive view of data refresh history and status for all Power Pivot workbooks. For more information, see Power Pivot Management Dashboard and Usage Data.

The data refresh history page provides detailed information about each refresh operation. You can use the information on this page to confirm whether refresh occurred or determine why it failed.

NameSpecifies the file name of the Excel workbook that contains Power Pivot data.
Current statusValues include Scheduled, Refreshing, Succeeded, or Failed.

 Scheduled appears when you first create the schedule. After data refresh runs the first time, this status message no longer appears.

 Refreshing indicates that data refresh is in progress. A request is either in the process queue or actively running on the server.

 Succeeded indicates that the last data refresh operation completed and the updated workbook is checked back into the SharePoint library.

 Failed indicates that the last data refresh operation did not succeed. The refreshed data was not saved. The workbook contains the same data it had before data refresh began.
Last successful refreshSpecifies the date on which the last data refresh completed successfully.
Next schedule refreshSpecifies the date on which the next data refresh is scheduled to occur.

The Configure schedule link takes you to the schedule definition page. If you have Contribute permissions on the workbook, you can click the link to view and modify the schedule information that controls unattended data refresh for Power Pivot data in the workbook.
StartedWithin the history details section, Started indicates the actual processing time. The actual processing time might be different from what you scheduled. Processing will begin when sufficient memory is available on the server. If the server is very busy, the processing might begin several hours after the start time you specified.
CompletedWithin the history details section, Completed indicates when the data refresh operation finished. The date and time indicates when the workbook was checked back into the library.

If data refresh fails, one or more error messages explain the cause of the failure. You can expand each record to view detailed status. Each data source is listed individually, alongside success or failure messages that explain why data refresh did not complete.
TimeProvides the cumulative time from when data refresh started to when it was completed.
StatusProvides a historical record of whether a refresh operation succeeded or failed.

Configure Usage Data Collection for (Power Pivot for SharePoint
Schedule a Data Refresh (Power Pivot for SharePoint)
Power Pivot Data Refresh

Community Additions