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