PowerPivot Sharepoint Data refresh error-version mismatch

Question

I am new to this PowerPivot and Sharepoint world.I can upload powerpivot documents in  Powerpivot gallery but ehnever I am trying to click "Manage Data Refresh' getting the below error-

SQL Server Analysis Services (PowerPivot) instance returnned the following error Error Code :3239968790 Description:The embedded PowerPivot Data in the workbook cannot be loaded due to version mismatch.





Answer 1

We have applied the SQL Server patch which we were missing now I am getting An Unexpected Error has occured.

We have reset IISRESET.What else shall I check?Please reply.

Answer 2

Hi Mousumi1,

Have you opened the workbook in a earlier version of PowerPivot, if so you cannot refresh newer version workbooks on a SQL Server 2008 R2 instance of PowerPivot for SharePoint. As SQL Server 2008 R2 PowerPivot workbooks reference MSOLAP.4, Microsoft SQL Server 2012 add-in will refer MSOLAP.5.  A SQL Server 2008 R2 instance will not process a workbook that you created in the Microsoft SQL Server 2012 Release Candidate 0 (RC 0) version of PowerPivot for Excel.

This is the same error message in this thread you can get some reference from this http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/thread/ef5c4016-148d-4aa5-b981-ee9720ce4d8c 

Thanks,

---

Challen Fu

TechNet Community Support

Answer 3

Thanks Challen Fu for your reply.I have 32 bit version of Excel 2010.I have created one report using the excel powerpivot and then uplodead that document in sharepoint powerpivot gallery.We have SQL Server 2008 R2.How to check the MOLAP reference?

What would be the next step to resolve the issue?