For couple of days I was cracking my head with this message in my Excel 2010 SP1 PowerPivot for SQL 2008 R2 x64. Error was:

Unable to load the Vertipaq engine.

If you click Details, the following call stack appears:

============================
Error Message:
============================

Exception from HRESULT: 0x800AC472

============================
Call Stack:
============================

Server stack trace:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at Microsoft.AnalysisServices.Modeler.FieldList.GeminiProxy.MethodInvokeCallBack(String memberName, String dispID, BindingFlags flags, Object[] args, Boolean ignoreRetry)
at Microsoft.AnalysisServices.Modeler.FieldList.GeminiProxy.HandleMethodInvoke(IMethodCallMessage callMessage)

Exception rethrown 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.Office.Interop.Excel.OLEDBConnection.Reconnect()
at Microsoft.AnalysisServices.Modeler.FieldList.InProcServer.LoadOLEDBConnection(Boolean raiseCompleteEvent)

============================

So I have found following article on http://support.microsoft.com/kb/2025669 but it did not solve my problem.

So I have finally downloaded latest version of Powerpivot for SQL 2012 from http://www.microsoft.com/download/en/details.aspx?id=28150 and VOILA!!! PowerPivot works, BUT….!!!

I have SharePoint Server 2010 on SQL 2008 R2 and xlsx file with PowerPivot data from SQL 2012 is unable to refresh itself automatically. So I have returned back to drawing board, and uninstalled PowerPivot SQL 2012 and installed 2008 R2 version. Error from beginning returned.

SOLUTION IS THIS: YOU NEED TO CHANGE REGIONAL SETTINGS TO ENGLISH. It is the only way. Now I’m compatible with my SharePoint 🙂

Advertisements