PowerPivot Problems in SharePoint Environment - CheckList - Solutions

Please verify the following checklist if you are having any problems with your PowerPivot configurations.

1. Central Administration -> Manage Services -> Go to PowerPivot Server -> SQL Server Analysis services is started

2. Verify if we can able to repair the powerpivot using PowerPivot Configuration Tool

3. SQL Browser service and SQL Analysis Service is started in PowerPivot Server

4. Check  SQL Server Analysis Services is using Domain Account?

5. Check whether PowerPivot solutions (PowerPivotFarm.wsp and PowerPivotWebApp.wsp) solutions are deployed properly in CA -> Manage Solutions

6. Can you able to open PowerPivot Service Application without any issues? CA -> Manage Service Applications -> PowerPivot Service Application

7. Please verify whether Claims to windows token service is started in PowerPivot servers?

8. Please verify whether UnattendedPowerPivot data refresh account is created in Secure Store Service. If  not create it. Otherwise you will get data refresh problems.