Issue-The Error was coming in SharePoint 2013 site when refreshing or clicking on any slicer of the Power table Report in excel 2013 workbook.
This issue occurs because the Analysis Services instance has not been configured in the Central Administration site.
Issue Solutions-Restart your SQL Server Analysis Server (PowerPivot) and Reset the IIS.
In most of the case above will fix your above Issue.
If in case the above method will not fix the Issue then configure the Excel Services service application on the SharePoint server. To do this, follow these steps:
1. In the Application Management section of the Central Administration home page, click Manage service applications.
2. On the Manage Service Applications page, click the Excel Services service application that you want to configure.
3. On the Manage Excel Services page, click Data Model.
4. Click Add Server.
5. In the Server Name box, type the name of the Analysis Services instance that you want to add.
6. Click OK.