Monday, November 18, 2013

PowerPivot: Usage data is not getting updated at the expected frequency

I was getting the below warning from Central Administration SharePoint Health Analyzer

Title:  PowerPivot: Usage data is not getting updated at the expected frequency. 
Severity:  2 - Warning 
Category:  Configuration 
Explanation:
The PowerPivot Management Data.xlsx file is not being updated. This workbook stores internal data used by the PowerPivot Management Dashboard. The current file for PowerPivot service application <0> was last updated 5 day(s) ago.


Resolution

1) Check under what account the PowerPivotUnattendedAccount is running.
2) Open SQL Management Studio and browse to Security -> Logins
3) Give db_datareader permission to PowerPivotUnattendedAccount for the PowerPivot Service Application database

No comments:

Post a Comment