Microsoft 电子表格软件系列,其中包含用于分析、绘制图表和传达数据的工具。
Hi Zaijian ZJ4 Luo,
Please feel free to post back if you have any update about it.
Best regards,
Jazlyn
i can import one file ,but when i import the second file show below error:
please help
Feedback Type:
Frown (Error)
Error Message:
Could not find a PackageSession for the given sessionID.
Stack Trace:
Error: Could not find a PackageSession for the given sessionID.
at KoFloatingDialog.initialize (ms-pq://pq.microsoft.com/ts/FloatingDialog/KoFloatingDialog.js:59:9)
at initialize (ms-pq://pq.microsoft.com/ts/FloatingDialog/SimpleDialog/KoPostImportQueriesDialog.js:9:9)
at Anonymous function (ms-pq://pq.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:28218)
at j (ms-pq://pq.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:26852)
at k.fireWith (ms-pq://pq.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:27609)
at e[] (ms-pq://pq.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:2:28632)
at Anonymous function (ms-pq://pq.microsoft.com/ts/FloatingDialog/KoFloatingDialog.js:156:5)
at n.event.dispatch (ms-pq://pq.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:3:6348)
at r.handle (ms-pq://pq.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:3:3114)
Stack Trace Message:
Could not find a PackageSession for the given sessionID.
Invocation Stack Trace:
在 Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
在 Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
在 Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.RaiseErrorDialog(IWindowHandle activeWindow, IUIHost uiHost, 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__DisplayClass14_0.<HandleException>b__0()
在 Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.FloatingDialog.OnError(String message, String stackTrace)
在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
在 Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass13_0.<InvokeMember>b__0()
在 Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
在 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.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
在 Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModalT
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.FloatingDialog.ShowDialogWithTimeout(IWindowHandle owner, Nullable`1 showTimeout)
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.KoPostImportQueriesDialog.Show(IWindowHandle owner, PackageReference packageReference, IUIHost uiHost, IEnumerable`1 importedQueries, Boolean allowTypeDetection)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowPostImportDialogProcessor.TryProcessImportedQueries(IEnumerable1 input, DataImportDestination destination, IEnumerable1& output)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.ProcessImportedQueries(IEnumerable`1 importedQueries, DataImportDestination destination)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass78_1.<OnQuerySettingsResolved>b__0()
在 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.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
在 Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModalT
在 Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope)
在 Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass12_1.<ShowModalQueriesEditorWindow>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, Action`1 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.TryShowModalEditor(IWindowHandle ownerWindow, IWorkbook workbook, Query query, Boolean isNewQuery, Boolean navigatorExpanded)
在 Microsoft.Mashup.Client.Excel.ExcelRibbonHandler.<>c__DisplayClass58_0.<OnShowEditorAction>b__0(IWorkbook workbook)
在 Microsoft.Mashup.Client.Excel.Shim.IWindowContextExtensions.TryInvokeOnParentWorkbook(IWindowContext windowContext, Action`1 action)
在 Microsoft.Mashup.Client.Excel.NativeRibbonHandler.<>c__DisplayClass6_0.<OnRibbonButtonAction>b__0()
在 Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
在 Microsoft.Mashup.Client.Excel.Native.NativeExcelCallbackInvoker.InvokeAndReturnHResult(Action action)
InnerException.Stack Trace Message:
Could not find a PackageSession for the given sessionID.
InnerException.Stack Trace:
在 Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageSessionStorage.GetLocalPackageSessionIndex(LocalPackageSessions localPackageSessions, Int32 sessionID)
在 Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageSessionStorage.GetLocalPackageSession(LocalPackageSessions localPackageSessions, Int32 sessionID)
在 Microsoft.Mashup.Host.Document.Storage.Local.LocalPackageSessionStorage.GetSessionStorage(PackagePath packagePath, PackageSession packageSession)
在 Microsoft.Mashup.Host.Document.Storage.TracingPackageSessionStorage.GetSessionStorage(PackagePath packagePath, PackageSession packageSession)
在 Microsoft.Mashup.Host.Document.Preview.PreviewManager.GetPreviewStatus(PreviewReference previewReference)
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.KoPostImportQueriesDialog.<CreateViewModel>b__7_0(Query q)
在 System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
在 System.Linq.Buffer1..ctor(IEnumerable1 source)
在 System.Linq.Enumerable.ToArrayTSource
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.KoPostImportQueriesDialog.CreateViewModel()
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.KoFloatingDialog.InternalCreateViewModel()
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.KoFloatingDialog.GetViewModel()
InnerException.Invocation Stack Trace:
在 Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
在 Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
在 Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
在 Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
在 Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.RaiseErrorDialog(IWindowHandle activeWindow, IUIHost uiHost, 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__DisplayClass14_0.<HandleException>b__0()
在 Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.FloatingDialog.OnError(String message, String stackTrace)
在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
在 Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass13_0.<InvokeMember>b__0()
在 Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
在 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.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
在 Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModalT
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.FloatingDialog.ShowDialogWithTimeout(IWindowHandle owner, Nullable`1 showTimeout)
在 Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.KoPostImportQueriesDialog.Show(IWindowHandle owner, PackageReference packageReference, IUIHost uiHost, IEnumerable`1 importedQueries, Boolean allowTypeDetection)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowPostImportDialogProcessor.TryProcessImportedQueries(IEnumerable1 input, DataImportDestination destination, IEnumerable1& output)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.ProcessImportedQueries(IEnumerable`1 importedQueries, DataImportDestination destination)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
在 Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass78_1.<OnQuerySettingsResolved>b__0()
在 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.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
在 Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModalT
在 Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope)
在 Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass12_1.<ShowModalQueriesEditorWindow>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, Action`1 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.TryShowModalEditor(IWindowHandle ownerWindow, IWorkbook workbook, Query query, Boolean isNewQuery, Boolean navigatorExpanded)
在 Microsoft.Mashup.Client.Excel.ExcelRibbonHandler.<>c__DisplayClass58_0.<OnShowEditorAction>b__0(IWorkbook workbook)
在 Microsoft.Mashup.Client.Excel.Shim.IWindowContextExtensions.TryInvokeOnParentWorkbook(IWindowContext windowContext, Action`1 action)
在 Microsoft.Mashup.Client.Excel.NativeRibbonHandler.<>c__DisplayClass6_0.<OnRibbonButtonAction>b__0()
在 Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
在 Microsoft.Mashup.Client.Excel.Native.NativeExcelCallbackInvoker.InvokeAndReturnHResult(Action action)
Supports Premium Content:
True
Microsoft 电子表格软件系列,其中包含用于分析、绘制图表和传达数据的工具。
锁定的问题。 此问题已从 Microsoft 支持社区迁移。 你可投票决定它是否有用,但不能添加评论或回复,也不能关注问题。
Hi Zaijian ZJ4 Luo,
Please feel free to post back if you have any update about it.
Best regards,
Jazlyn
Hi Zaijian ZJ4 Luo,
Thank you for the reply.
You mentioned that you were using RPA to trigger the power query, to check whether the problem is related to the Excel application or the RPA software, could you please try triggering the power query step by step manually?
Best regards,
Jazlyn
Hi Zaijian ZJ4 Luo,
Sorry for the inconvenience this problem caused.
Per your description, there’s a few points that need to be clarified so that we can help you. For example, you mentioned “import one file”, I want to confirm where did you import the Excel file, SharePoint Online or other place?
We may need to ask for more details regarding the whole process. If possible please tell more information like below:
Appreciate your cooperation in advance.
Best regards,
Jazlyn