Pivot Table Operation Failed: An error occurred while working on the Data Model in the workbook.

Recently I got this error while I was trying to a refresh on an Excel document which had PowerPivot on it.

Pivot Table Operation Failed: An error occurred while working on the Data Model in the workbook. Please try again.

How did this happen

1) Sharepoint Farm is set up.

2) Excel Services is configured as service application

3) PowerPivot Installed and Configured to work

4) Installed Office Web Application later

What happens in this scenario?

The Excel can be opened either with Excel Services or Office Web Apps. But since Office Web Apps was installed last, it over rides the Excel Service Application features for Excel documents.

I have posted an article on the difference between Excel Services for Sharepoint and Excel Web App here.

How did I fix this?

I ran the New-SPWOPISuppressionSetting command and fixed it. The details are here.