Sharepoint powerpivot 2010

Environment : Sharepoint 2010, Powerpivot 2010, Sql server 2008 R2

 The slicers in excel powerpivot that were deployed to sharepoint 2010 are not working. Also I am unable to configure the refresh options for the power pivot reports.
                              When I click on Configure the the refresh link its shows unexcpeted error and when checked with logs files , here is the details.
                              Could you please let me know how to fix the issue?

When I try to open the report in sharepoint , it shows error in screenshot.

0x01FC  Excel Services Application            Excel Calculation Services             d51n      Medium                  MossHost.GetEndpointAddress: Server endpoint Uri: http://sp-prd-pp01:32843/b491c3eba6a5438daeb3c9c66ee0ffef/ExcelService.asmx.    640ccb0f-2f18-4218-9ed1-07bdb9927df1
                              05/08/2015 08:26:30.02 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/b491c3eba6a5438daeb3c9c66ee0ffef/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetHealthScore' MessageId: 'urn:uuid:b59d8030-acf2-4b3c-bace-4d6628e55202' 640ccb0f-2f18-4218-9ed1-07bdb9927df1
                              05/08/2015 08:26:32.50 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Monitoring                                    nasq      Medium               Entering monitored scope (Request (GET:https://gohsep.net:443/rec/_layouts/PowerPivot/ManageDataRefresh.aspx?list=%7b6AE4477D-1469-4766-B8D1-2DEDC0C70227%7d&ID=8&Source=https%3a%2f%2fgohsep.net%2frec%2fGM%2520Dashboard%2fForms%2fGallery.aspx))             
                              05/08/2015 08:26:32.50 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Logging Correlation Data                      xmnv     Medium               Name=Request (GET:https://gohsep.net:443/rec/_layouts/PowerPivot/ManageDataRefresh.aspx?list=%7b6AE4477D-1469-4766-B8D1-2DEDC0C70227%7d&ID=8&Source=https%3a%2f%2fgohsep.net%2frec%2fGM%2520Dashboard%2fForms%2fGallery.aspx)                456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.50 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Logging Correlation Data                      xmnv     Medium               Site=/rec             456d444d-1f5d-4bd3-a49a-161e45f60cb2
                               05/08/2015 08:26:32.53 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Monitoring                         b4ly                High       Leaving Monitored Scope (EnsureListItemsData). Execution Time=14.4548399307733      456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.55 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/f1e524780f8f45598b197fa12df36130/SSASMidTierService.svc' Channel: 'Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplicationClient' Action: 'http://tempuri.org/IGeminiServiceApplication/GetDataRefreshSchedule' MessageId: 'urn:uuid:fac7fc8c-d793-4cab-bfaa-153ccc37c773'    456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.61 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/f1e524780f8f45598b197fa12df36130/SSASMidTierService.svc' Channel: 'Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplicationClient' Action: 'http://tempuri.org/IGeminiServiceApplication/GetDatabase' MessageId: 'urn:uuid:a17e3b9f-6f53-42b0-8049-e60445fa7c10'    456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.66 w3wp.exe (0x0188)                       0x38D0 SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-apps02:32843/970d02b3d5814a54ae5bca029a178cbd/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:ae2a33d5-fb8f-4f25-9295-490006908835'        
                              05/08/2015 08:26:32.66 w3wp.exe (0x0574)                       0x0474  SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-apps02:32843/970d02b3d5814a54ae5bca029a178cbd/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:bf2bffa2-b695-4871-865a-ba986b6bb640'       
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Monitoring                         b4ly                High       Leaving Monitored Scope (ExecuteWcfOperation:http://tempuri.org/IGeminiServiceApplication/GetDatabase). Execution Time=556.589594487568                456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC  SSAS Mid-Tier Service                    Unknown                            99                High       EXCEPTION: System.ServiceModel.Security.SecurityAccessDeniedException: Access is denied.    Server stack trace:      at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)     at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)     at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)     at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)     at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)    Exception re...   456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17*               w3wp.exe (0x0188)                       0x01FC  SSAS Mid-Tier Service                    Unknown                                       99           High       ...thrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplication.GetDatabase(String loginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Boolean collectHeathInfo, Boolean createLocal, String serverEndpointAddress)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplicationProxy.GetDatabaseHelper(String loginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Boolean collectHeathInfo, Boolean createLocal)  456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC  SSAS Mid-Tier Service                    Unknown                            15                Medium               Proxy encountered an error while trying to get the sandbox information. This request will be terminated         456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Runtime                               tkau                Unexpected       System.ServiceModel.Security.SecurityAccessDeniedException: Access is denied.   Server stack trace:      at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)     at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)     at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)     at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)     at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)    Exception rethrown at [0...          456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17*               w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Runtime                                       tkau       Unexpected       ...]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplication.GetDatabase(String loginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Boolean collectHeathInfo, Boolean createLocal, String serverEndpointAddress)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplicationProxy.GetDatabaseHelper(String loginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Boolean collectHeathInfo, Boolean createLocal)     at Microsoft.AnalysisServices.SharePoi...          456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17*               w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Runtime                                       tkau       Unexpected       ...nt.Integration.GeminiServiceApplicationProxy.GetDatabase(StringloginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Int64 totalLength, String& databaseId, String& databaseName, String& serverEndpointAddress)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplicationProxy.GetDataRefreshSchedule(String url, Guid itemID, Boolean loadDataSources)     at Microsoft.AnalysisServices.SharePoint.Integration.DataRefreshUtils.GetRefreshSchedule(String url, Boolean loadDataSources)     at Microsoft.AnalysisServices.SharePoint.Integration.ManageRefresh.Page_Load(Object sender, EventArgs e)     at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)     at System.Web.Util.CalliEventHa...               456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17*               w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Runtime                                       tkau       Unexpected       ...ndlerDelegateProxy.Callback(Object sender, EventArgs e)     at System.Web.UI.Control.OnLoad(EventArgs e)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiPageBase.OnLoad(EventArgs e)     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)            456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC  SharePoint Foundation                 Monitoring                         b4ly                Medium               Leaving Monitored Scope (Request<input id="720634c8-24f9-446b-8809-300a396697ad_attachments" type="hidden"
May 27th, 2015 5:04pm

Hi,have you set permission on the web application level for you BI account?

$wa=get-spwebapplication http://intranet

$wa.GrantAccessToProcessIdentity("myDomain\bi_account")

Hope it helps

Free Windows Admin Tool Kit Click here and download it now
May 31st, 2015 12:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics