Tag Archives: Error Message

Error Processing the PowerPivot Management Dashboard

Symptoms

There is a timer job called “PowerPivot Management Dashboard Processing Timer Job” that, by default, runs daily.  This process relies on the secure store service to authenticate to the data source.  If the permissions on the SSS target application are not correct, you will receive an “Access is denied to the secure store service” error when this timer job runs.

clip_image002

Solution

Check the SSS ID for the Refresh Account

$ppv = Get-PowerPivotServiceApplication

$ppv | fl *Account*

Next, open the SSS and edit the Target Application that corresponds to the one that the PowerPivot service application is using.

clip_image004

On the third page of the edit wizard, ensure that the farm account and the service application account for PowerPivot are in the Members list:

clip_image006

Lastly, Re-Run the Dashboard Processing Timer Job by clicking Run Now on the timer job definition page, or you can run script below.

Get-SPTimerJob “PowerPivot Dashboard Processing Timer Job” | Start-SPTimerJob

clip_image008

Result

You should now see that the cube has been processed on the PowerPivot management dashboard!

clip_image010