locked
Power Query not working RRS feed

  • Question

  • My Power Query commands have stopped working it doesn't allow me to Import data from External Source, neither from Excel, Text file etc. I get below mentioned error I have submitted error information multiple times but no reply

    Feedback Type:
    Frown (Error)

    Error Message:
    Error

    Stack Trace:
    Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xFFFFFFFF. PID: 11332.
    Used features: (none). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xFFFFFFFF. PID: 11332.
    Used features: (none). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xFFFFFFFF. PID: 11332.
    Used features: (none). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xFFFFFFFF. PID: 11332.
       at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
       at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
       at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
       at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
       at Microsoft.Mashup.Evaluator.RemoteServiceEnvironment.CreateServiceStubs(IMessenger messenger, IEngineHost engineHost)
       at Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.Container.Initialize()
       at Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.CreateContainer()
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.CreateContainer()
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryCompleteWithException(Exception exception)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
       at Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
       at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
       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.Threading.ThreadHelper.ThreadStart(Object obj)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

    Stack Trace Message:
    Error

    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.Excel.Native.NativeUserFeedbackServices.RaiseErrorDialog(IWindowHandle activeWindow, IUIHost uiHost, 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.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)
       at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
       at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
       at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass62_0.<GetPreviewResult>b__1()
       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.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
       at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass56_0.<InvokeOnWorkbook>b__0(IWorkbook workbook, IWindowContext windowContext)
       at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbook[T](Func`3 action, T defaultValue)
       at Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
       at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass78_1.<OnQuerySettingsResolved>b__0()
       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)


    Supports Premium Content:
    True

    ExceptionResultMessage:
    Container exited unexpectedly with code 0xFFFFFFFF. PID: 11332.
    Used features: (none).

    Formulas:


    section Section1;

    shared PQ_SplitColumn1 = let
        Source = File.Contents("C:\Users\Sanjay\Desktop\DataAnalytics\PowerQuery\PQ_SplitColumn1.xlsx")
    in
        Source;

    Monday, July 20, 2020 6:20 AM

All replies

  • Hi Sanjay,

    To troubleshoot this issue, you can follow the steps below:

    1.Delete cache for Power query:

    (Please back up your data before you take the action.)

    C:\Users\username\AppData\Local\Microsoft\Power Query\Cache) and deleted all files found there.  

    It also can be found here:

    Simply go to Options -> Global -> Data Load and click Clear Cache.

    2.The problem may be caused by windows system files damage, please go to Windows Settings to check for updates to make sure you have installed the latest Windows updates and security updates.

    Then try the following methods and check if it helps:

     Perform System File Checker (SFC) scan:

        i. Open CMD (Admin)

        ii. Type sfc /scannow and then press ENTER

     Fix Windows corruption errors by using the DISM:

        i. Open CMD (Admin)

        ii. Type the following commands in command prompt one by one and press Enter after each command:

          -      Dism /Online /Cleanup-Image /CheckHealth

          -      Dism /Online /Cleanup-Image /ScanHealth

          -      Dism /Online /Cleanup-Image /RestoreHealth

    3.Update Excel to the latest version.

    This “Excel IT Pro Discussions” Forum will be migrating to a new home on Microsoft Q&A, please refer to this sticky post for more details.

    Best regards

    Itch Sun



    "Office" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "Office" forums' new home on Microsoft Q&A !

    Monday, July 20, 2020 7:52 AM