Issue:
In SharePoint 2010 with SQL server 2012 for powerpivot services, we unable to click on "PowerPivot Management Dashboard" and in ULS log the error was like as below:
Background file fill operation caught exception: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'proc_FetchChunkFromDocStreams', database 'DEVBISP2010_Content_Admin', schema 'dbo
Resolution:
Need to provide DbWriter and DBreader permission to Powerpivot service application app pool account at admin content DB.
