"Unable to load the Vertipaq engine" error message when you work with PowerPivot workbooks that have linked tables that receive data from an external data source


Consider the following scenario:

  • You work with linked tables in PowerPivot workbooks.
  • The linked tables receive data from an external data source.
  • This external data source is not available.

In this scenario, you may receive the following error message:

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)


To resolve this problem, relaunch the PowerPivot window to view the PowerPivot data.



Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.