"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


Symptoms


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)
 
============================

Resolution


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

 

Status

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