I have given connection between Sql service analysis filter web-part and Excel-Web access web-part when I try to filter it I am not getting filtration in Excel-Web access web-part and showing error as below.Can any one help me how can I solve this
enable the powerpivot service or set it up.
Excel Services returns this error when you query PowerPivot data in an Excel workbook that is published to SharePoint, and the SharePoint environment does not have a PowerPivot for SharePoint server, or the SQL Server Analysis Services (PowerPivot) service is stopped.
The error occurs when you slice or filter PowerPivot data when the query engine is not available.
For PowerPivot workbooks that were created in a SQL Server 2008 R2 version of PowerPivot for Excel, you must install the SQL Server 2008 R2 version of the Analysis Services OLE DB provider. This error will occur if you installed the provider, but did not register the Microsoft.AnalysisServices.ChannelTransport.dll file. For more information about file registration Install the Analysis Services OLE DB Provider on SharePoint Servers
The second scenario is when you have a server in a SharePoint farm that runs Excel Services, but not PowerPivot for SharePoint. In this case, the application server that runs Excel Services must be manually updated to use both the newer version of the provider, as well as install an instance of the Microsoft.AnalysisServices.Xmla.dll file in the global assembly. These components are necessary for connecting to a PowerPivot for SharePoint instance. If Excel Services is using an older version of the provider, the connection request will fail.
just follow the directions in the link:
scroll down to:
Install the SQL Server 2008 R2 OLE DB Provider to host earlier version workbooks
Install the SQL Server 2012 OLE DB Provider on an Excel Services server