PowerQuery表刷新因错误而停止 [英] PowerQuery table refresh stops with an error

问题描述

我遇到过几次情况，使用电源查询和刷新大表(约30万行)会停止加载出现错误的行:

I have experienced several time situation where using power query and refreshing large table (~300K rows) it stops loading rows with an error:

错误消息:

MashupResource的PageReader不可用.

The MashupResource's PageReader is not available.

堆栈跟踪:

System.InvalidOperationException:MashupResource的PageReader是无法使用.在Microsoft.Mashup.Client.Excel.FillManager.RefreshFillSession.GetSchemaInfo()在Microsoft.Mashup.Client.Excel.FillManager.RefreshFillSession.CompleteRefresh(IWorkbook工作簿，布尔onTimer)位于Microsoft.Mashup.Client.Excel.FillManager.RefreshFillSession.UpdateRefreshStatus(IWorkbook工作簿，布尔onTimer)位于Microsoft.Mashup.Client.Excel.FillManager.RefreshFillSession.ResumeFill(布尔onTimer)Microsoft.Mashup.Client.Excel.FillManager.UpdateQueries()在Microsoft.Mashup.Client.Excel.FillManager.b__5()在Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandlerexceptionHandler，Action操作)

System.InvalidOperationException: The MashupResource's PageReader is not available. at Microsoft.Mashup.Client.Excel.FillManager.RefreshFillSession.GetSchemaInfo() at Microsoft.Mashup.Client.Excel.FillManager.RefreshFillSession.CompleteRefresh(IWorkbook workbook, Boolean onTimer) at Microsoft.Mashup.Client.Excel.FillManager.RefreshFillSession.UpdateRefreshStatus(IWorkbook workbook, Boolean onTimer) at Microsoft.Mashup.Client.Excel.FillManager.RefreshFillSession.ResumeFill(Boolean onTimer) at Microsoft.Mashup.Client.Excel.FillManager.UpdateQueries() at Microsoft.Mashup.Client.Excel.FillManager.b__5() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

调用堆栈跟踪:

在Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()在Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(StringexceptionStackTrace，String invocationStackTrace)在Microsoft.Mashup.Client.ClientShared.ErrorDetails..ctor(字符串消息，Nullable`1 errorCode，字符串requestId，Exception异常)在Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<> c__DisplayClass1.b__0()在Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.Send(SynchronizationContext上下文，IExceptionHandler exceptionHandler，Action回调)Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception吃Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandlerexceptionHandler，Action操作)在Microsoft.Mashup.Client.Excel.FillManager.OnFillUpdateTimerTick(对象发送方，EventArgs eventArgs)，网址为System.Windows.Forms.Timer.OnTick(EventArgs e)位于System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message&m)位于System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd，Int32 msg，IntPtr wparam，IntPtr lparam)

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace) at Microsoft.Mashup.Client.ClientShared.ErrorDetails..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception) at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.Send(SynchronizationContext context, IExceptionHandler exceptionHandler, Action callback) at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Mashup.Client.Excel.FillManager.OnFillUpdateTimerTick(Object sender, EventArgs eventArgs) at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

MashupResource.Status初始化

MashupResource.Status Initializing

当某些表正在刷新并且我尝试使用其他Excel文件时，出现此错误.有人知道这是什么意思吗?我尝试在Google中搜索它，但没有成功.

I get this error when some table is refreshing and I try to use other excel file. Do anyone have an idea what does it mean? I have tried searching it in google with no success.

我正在使用Excel 2010 32位版本14.0.7015.1000和PowerQuery版本2.27.4163.242

I am using Excel 2010 32bit, version 14.0.7015.1000 and PowerQuery version 2.27.4163.242

推荐答案

很抱歉您遇到了这个问题，消息表明Power Query中存在一些错误.

Sorry you ran into this problem, the message indicates there's some bug in Power Query.

如果您可以尝试升级到最新的公共Power Query(我们现在的版本为2.30)，问题是否就消失了?

If you could try upgrading to the latest public Power Query (we're at version 2.30 now) does the problem go away?

如果没有，那么从错误提示发送皱眉可能是最简单的方法，您可以与我们超级有用的支持团队联系吗?

If not, it might be easiest to Send a Frown from the error prompt and you can get in touch with our super-helpful support team?

这篇关于PowerQuery表刷新因错误而停止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！