엑셀 파워쿼리 오류

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
원본;

Answer 1

이 응답은 자동으로 번역되었습니다. 따라서 문법 오류 또는 이상한 표현이 있을 수 있습니다.

안녕하세요. 키 비 고객님

Microsoft 커뮤니티를 방문해 주셔서 감사합니다.

Microsoft 파워 쿼리와 관련된 문제가 발생했습니다. 그러나 커뮤니티에는 파워 쿼리 관련 지식이 적으므로 경험이 풍부한 전문가가 조언을 제공할 수 있는 Microsoft Fabric Community Power Query - Microsoft Fabric Community의 해당 섹션에 이 문제를 게시하는 것이 좋습니다.

저는 지침을 제공할 수 있는 훌륭한 자원 봉사자를 기대하면서 이 주제를 계속 열어두겠습니다.

감사합니다

조나단 Z - MSFT | Microsoft 커뮤니티 지원 전문가