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

 
 
 Posts
Posts
 
 
No comments:
Post a Comment