none
Querying a group.member in AD domain- Evaluation resulted in a stack overflow and cannot continue RRS feed

  • Question

  • I want know the members of group in AD, so I getting this error below :

    Power BI version: 2.76.5678.782

    Feedback Type:
    Frown (Error)


    Error Message:
    O contêiner saiu inesperadamente com o código 0xC0000005.
    Recursos usados: (nenhum).

    Stack Trace:
    Microsoft.Mashup.Evaluator.Interface.ErrorException: O contêiner saiu inesperadamente com o código 0xC0000005.
    Recursos usados: (nenhum). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: O contêiner saiu inesperadamente com o código 0xC0000005.
       em Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
       em Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
       --- Fim do rastreamento de pilha de exceções internas ---
       em Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
       em Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
       em Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
       em Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
       em Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
       em Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
       em Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()
       em Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

    Stack Trace Message:
    O contêiner saiu inesperadamente com o código 0xC0000005.
    Recursos usados: (nenhum).

    Invocation Stack Trace:
       em Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
       em Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo)
       em Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
       em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
       em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
       em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       em System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       em System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       em System.Delegate.DynamicInvokeImpl(Object[] args)
       em System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
       em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
       em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
       em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
       em System.Windows.Forms.Control.WndProc(Message& m)
       em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       em System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
       em System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       em System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       em System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
       em Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__FabricatedMethod8(IWindowHandle )
       em Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
       em Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
       em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
       em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
       em Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>c__DisplayClassc.<OnAjaxException>b__b()
       em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       em System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       em System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       em System.Delegate.DynamicInvokeImpl(Object[] args)
       em System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
       em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
       em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
       em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
       em System.Windows.Forms.Control.WndProc(Message& m)
       em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       em System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
       em System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       em System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       em System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
       em Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__FabricatedMethod8(IWindowHandle )
       em Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
       em Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope)
       em Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass5.<ShowModalQueriesEditorWindow>b__1(IUndoScope undoScope)
       em Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
       em Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
       em Microsoft.Mashup.Client.Excel.DialogManager.TryShowModalEditor(IWindowHandle ownerWindow, IWorkbook workbook, Query query, Boolean isNewQuery, Boolean navigatorExpanded)
       em Microsoft.Mashup.Client.Excel.ExcelQueryServices.<>c__DisplayClass1b.<EditQuery>b__1a(IWorkbook workbook)
       em Microsoft.Mashup.Client.Excel.ExcelQueryServices.TryInvokeOnWorkbook(Action`1 action)
       em Microsoft.Mashup.Client.Excel.TaskPaneControls.TaskPaneControl.NotifyGetDataPresence(Action action)
       em Microsoft.Mashup.Client.Excel.TaskPaneControls.QueriesTaskPaneControlBase.<>c__DisplayClass53.<EditQueryAsync>b__52()
       em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       em System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       em System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       em System.Delegate.DynamicInvokeImpl(Object[] args)
       em System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
       em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
       em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
       em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
       em System.Windows.Forms.Control.WndProc(Message& m)
       em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    Supports Premium Content:
    True

    Formulas:


    section Section1;

    shared group = let
        Fonte = ActiveDirectory.Domains("net.ebs.com.br"),
        net.ebs.com.br = Fonte{[Domain="net.ebs.com.br"]}[#"Object Categories"],
        group1 = net.ebs.com.br{[Category="group"]}[Objects],
        #"Outras Colunas Removidas1" = Table.SelectColumns(group1,{"distinguishedName", "group", "displayName"}),
        #"Linhas Filtradas" = Table.SelectRows(#"Outras Colunas Removidas1", each ([distinguishedName] = "CN=GXX-SXX-FILE-SXXX-DXX-CXX-R,OU=File Server,OU=Grupos,OU=SXX,OU=EBS,DC=net,DC=ebs,DC=com,DC=br")),
        #"group Expandido" = Table.ExpandRecordColumn(#"Linhas Filtradas", "group", {"member"}, {"member"}),
        #"member Expandido" = Table.ExpandListColumn(#"group Expandido", "member"),
        member = #"member Expandido"{0}[member]
    in
        member;




    • Edited by Joel Melo Monday, January 20, 2020 8:31 PM version of power bi
    Monday, January 20, 2020 8:27 PM

Answers