컨테이너가 예기치 않게 종료되었습니다. 코드: 0xC0000005. PID: 11420.

Question

파워쿼리에 오류가 계속 발생됩니다. 어떻게 해결하죠

Feedback Type: Frown (Error)

Error Message: 컨테이너가 예기치 않게 종료되었습니다. 코드: 0xC0000005. PID: 11420. 사용된 기능: (없음).

Stack Trace: Microsoft.Mashup.Evaluator.Interface.ErrorException: 컨테이너가 예기치 않게 종료되었습니다. 코드: 0xC0000005. PID: 11420. 사용된 기능: (없음). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: 컨테이너가 예기치 않게 종료되었습니다. 코드: 0xC0000005. PID: 11420. 위치: Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read() 위치: Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read() --- 내부 예외 스택 추적의 끝 --- 위치: Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read() 위치: Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel) 위치: Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read() 위치: Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitForT 위치: Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func1 condition, Boolean disposing) 위치: Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue() 위치: Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue() 위치: Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult21 result, Func1 getStaleSince, Func1 getSampled)

Stack Trace Message: 컨테이너가 예기치 않게 종료되었습니다. 코드: 0xC0000005. PID: 11420. 사용된 기능: (없음).

Invocation Stack Trace: 위치: Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() 위치: Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable1 stackTraceInfo, String messageDetail) 위치: Microsoft.Mashup.Client.UI.Windows.UIHost.RaiseErrorDialog(IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture) 위치: Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture) 위치: Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.b__0() 위치: Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) 위치: Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) 위치: System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) 위치: System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) 위치: System.Delegate.DynamicInvokeImpl(Object[] args) 위치: System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) 위치: System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) 위치: System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 위치: System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 위치: System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) 위치: System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) 위치: System.Windows.Forms.Control.InvokeMarshaledCallbacks() 위치: System.Windows.Forms.Control.WndProc(Message& m) 위치: System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) 위치: System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) 위치: System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) 위치: System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form) 위치: System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) 위치: System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) 위치: System.Windows.Forms.Form.ShowDialog(IWin32Window owner) 위치: Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle) 위치: Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner) 위치: Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func1 showModalFunction) 위치: Microsoft.Mashup.Client.Excel.QueriesEditorWindow.ShowModal(IUIHost uiHost, FormulaHistoryManager formulaHistoryManager, ApplicationTracingHost applicationTracingHost, ExcelServices excelServices, ConnectionManager connectionManager, DialogManager dialogManager, FillManager fillManager, PackageManager packageManager, IFileDialogManager fileDialogManager, ITelemetryService telemetryService, IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries) 위치: Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope) 위치: Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass13_1.b__1(IUndoScope undoScope) 위치: Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action) 위치: Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action) 위치: Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action1 action) 위치: Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action) 위치: Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries) 위치: Microsoft.Mashup.Client.Excel.DialogManager.AddExcelTable(IWindowHandle ownerWindow, IWorkbook workbook, String tableName, String newQueryName) 위치: Microsoft.Mashup.Client.Excel.DialogManager.AddExcelTable(IWindowContext windowContext, IWorkbook workbook) 위치: Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action) 위치: Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action) 위치: Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action1 action) 위치: Microsoft.Mashup.Client.Excel.Shim.IWindowContextExtensions.TryInvokeOnParentWorkbook(IWindowContext windowContext, Action`1 action) 위치: Microsoft.Mashup.Client.Excel.NativeRibbonHandler.<>c__DisplayClass6_0.b__0() 위치: Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) 위치: Microsoft.Mashup.Client.Excel.Native.NativeExcelCallbackInvoker.InvokeAndReturnHResult(Action action)

Supports Premium Content: False

Formulas:

section Section1;

shared 표1 = let 원본 = Excel.CurrentWorkbook(){[Name="표1"]}[Content], #"가입연월 및 쿠폰 필터" = Table.SelectRows(원본, each [쿠폰금액] <> null or [가입연월] = "24-12") in #"가입연월 및 쿠폰 필터";

shared #"표1 (2)" = let 원본 = Excel.CurrentWorkbook(){[Name="표1"]}[Content] in 원본;