Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
stjani
New Member

Power Query error when executing a formula

Hello everyone,

We get this error when executing a formula in Excel

Feedback Type:
Frown (Error)

Error Message:
Container unexpectedly exited. Exit code: 0xC000026F. PID: 23028

Stack Trace:
   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

Stack Trace Message:
Container unexpectedly exited. Exit code: 0xC000026F. PID: 23028

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
   at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)
   at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
   at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
   at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
   at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.Mashup.Client.Excel.QueriesEditorWindow.ShowModal(ILegacyUIHost uiHost, FormulaHistoryManager formulaHistoryManager, ApplicationTracingHost applicationTracingHost, ExcelServices excelServices, ConnectionManager connectionManager, DialogManager dialogManager, IFillManager fillManager, LoadQueryManager loadQueryManager, PackageManager packageManager, IFileDialogManager fileDialogManager, IInteractiveMsalProvider msalProvider, ITelemetryService telemetryService, IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IOfficeRegistryAccessor officeRegistryAccessor)
   at Microsoft.Mashup.Client.Excel.UI.LegacyMashupClientUIServices.ShowQueriesEditorWindow(WindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, QueryServices queryServices, Queries queries, QueryDefinition queryDefinition)
   at Microsoft.Office.PowerQuery.Adapter.MixedMashupClientUIServices.ShowQueriesEditorWindow(WindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, QueryServices queryServices, Queries queries, QueryDefinition queryDefinition)
   at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope, QueryDefinition queryDefinition)
   at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass15_0.<ShowModalQueriesEditorWindow>b__1(IUndoScope undoScope)
   at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
   at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
   at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
   at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
   at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, QueryDefinition queryDefinition)
   at Microsoft.Mashup.Client.Excel.UI.LegacyMashupClientUIServices.AddExcelNamedObject(WindowHandle ownerWindow, IWorkbook workbook, WorkbookPackage workbookPackage, String newQueryName, String formulaText)
   at Microsoft.Office.PowerQuery.Adapter.MixedMashupClientUIServices.AddExcelNamedObject(WindowHandle ownerWindow, IWorkbook workbook, WorkbookPackage workbookPackage, String newQueryName, String formulaText)
   at Microsoft.Mashup.Client.Excel.DialogManager.AddExcelNamedObject(IWindowHandle ownerWindow, IWorkbook workbook, String namedObjectName, String newQueryName)
   at Microsoft.Mashup.Client.Excel.NativeExcelConnectorC2RBase.<>c__DisplayClass68_0.<CreateCurrentWorkbookQuery>b__0()
   at Microsoft.Mashup.Client.Excel.Native.NativeExcelCallbackInvoker.InvokeAndReturnHResult(Action action)
   at Microsoft.Mashup.Client.Excel.NativeExcelConnectorC2RBase.CreateCurrentWorkbookQuery(IntPtr uiFrame, IntPtr workbookPointer, MarshalledNamedObjectIdentifier namedObjectIdentifier)


Supports Premium Content:
True

Formulas:


section Section1;

shared TestTbl = let
    Source = Excel.CurrentWorkbook(){[Name="TestTbl"]}[Content]
in
    Source;

Works for his colleagues, its just him that gets the error. Fully updated Windows 11 Pro. User has M365 apps for Enterprise and Business Premium license - why both I don't know. I have a feeling this could be due to a new Office365 update since last week, it was working for him.

We have tried

- Creating a new local Windows profile.
- Repairing/reinstalling Office365.
- Clearing Power Query cache.
- Repairing/reinstalling .NET 4.0 & VCRedists
- excel /safe — same error.

Any help would be appreciated. 

1 ACCEPTED SOLUTION

Hi Tailor and thanks for your reply,

Problem was sovled. There was a pending Office365 update (possible hotfix for this issue?). Also did /sfc scannow and dism.exe /online /cleanup-image /restorehealth and problem was solved after a reboot.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @stjani ,

 

Thank you for contacting the Microsoft Fabric Community Forum. I appreciate your confirmation that the issue has been resolved. Please continue to use the forum if you have any further questions.

tayloramy
Super User
Super User

Hi @stjani

 

Can you give some more details? 
What is excel connecting to? Is it connecting to a Power BI Semantic Model? 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 





If you found this helpful, consider giving some Kudos.
If I answered your question or solved your problem, mark this post as the solution!

Proud to be a Super User!





Hi Tailor and thanks for your reply,

Problem was sovled. There was a pending Office365 update (possible hotfix for this issue?). Also did /sfc scannow and dism.exe /online /cleanup-image /restorehealth and problem was solved after a reboot.

Helpful resources

Announcements
FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Fabric Update Carousel

Fabric Monthly Update - March 2026

Check out the March 2026 Fabric update to learn about new features.