PivotTable Operation Failed - "An error occurred while working on the Data Model in the workbook"

I recently came upon this error when clicking on slicers in a PowerPivot report published to SharePoint 2013:

Fix: Try restarting both the SQL Server Analysis Services (POWERPIVOT) service and SQL Server PowerPivot System Service

1. Restart SQL Server Analysis Services (POWERPIVOT) service
• Has to be done on the server PowerPivot was set up on -- if you do not know the server go to Central Administration > Application Management > Manage service applications > select the Excel Service Application > Data Model Settings > server name will show up here if it has been set up. If there is no server listed here then this piece of the configuration MUST be completed! Refer to this TECHNET article)


2. Restart SQL Server PowerPivot System Service
• Central Administration > System Settings > Manage services on server > Stop and start the SQL Server PowerPivot System Service

The following technet article explains service dependencies and the effects of restarting these services. I recommend reviewing this before implementing the fix: http://technet.microsoft.com/en-us/library/ee637437(v=sql.105).aspx

Coming Soon...