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_datareaderpermission to PowerPivotUnattendedAccount for the PowerPivot Service Application database
No comments:
Post a Comment