nuestro flujo de datos es kusto->sqlserver->powerbidataset. La actualización de datos funciona bien en los últimos días, pero recientemente falló con el mensaje de error "La clave dada no estaba presente en el diccionario" en destop powerbi. El conjunto colmun compare entre sql server y powerbi muestra que el conjunto de nombres de columna es el mismo, pero el orden del conjunto de columnas es diferente. ¿Es posible que powerbi se actualice manualmente debido al orden descorcharetable del conjunto de columnas entre sql Server y powerbi? Tenga en cuenta que el conjunto de datos de actualización de programación en web funciona bien. Yo soy un nuevo en el powerbi, cualquier ayuda será muy apreciada.
Mensaje de error:
La clave dada no estaba presente en el diccionario.
Rastreo de pila:
en System.ThrowHelper.ThrowKeyNotFoundException()
en System.Collections.Generic.Dictionary'2.get_Item(tecla TKey)
en Microsoft.PowerBI.Client.Windows.Modeling.LoadToReportProgress.<UpdateImportProgress>b__22_0()
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
Mensaje de seguimiento de pila:
La clave dada no estaba presente en el diccionario.
Seguimiento de pila de invocación:
en Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
en Microsoft.Mashup.Client.UI.Shared.StackTraceInfo.. ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
en Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
en Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
en Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
en Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
en Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
en System.Windows.Forms.Timer.OnTick(EventArgs e)
en System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
en System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
en System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
en System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
en Microsoft.PowerBI.Client.Windows.CefHtmlForm.<>n__0(IWindowHandle windowHandle)
en Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func'1 showModalFunction)
en Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.TryShowDialog(Informe, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IQueryServices queryServices, IModelingService modelingService, IUIHost uiHost, LocalizedString title, LoadToModelContext loadToModelContext, IEventAggregationService eventAregggationService)
en Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.TryShowDialogForQueries(Informe, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IUIHost uiHost, IQueryServices queryServices, IEnumerable'1 queriesToLoad, String loadReason, IEventAggregationService eventAggregationService, LocalizedString title, Boolean requireFullDataRefresh, IEnumerable'1 queriesRequiringTableDefinitionGeneration, IEnumerable'1 queriesToEvaluateForFoldedArtifacts, IEnumerable'1 queriesToSynchronizeOnly, ModelChange modelChangeToExecuteBeuteDeSchemaSync)
en Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.<>c__DisplayClass19_0.<<RouteToLocalModel>b__0>d.MoveNext()
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
en Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.<>c__DisplayClass19_0.<RouteToLocalModel>b__0()
en Microsoft.PowerBI.Client.Windows.Modeling.ModelingTelemetryHelper.ExecuteAndLogModelChangeEvent(ModelChange value, EditorView source, IPowerBITelemetryService telemetryService, Func'1 modelChangeFunc)
en Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.<RouteToLocalModel>d__19.MoveNext()
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
en Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.RouteToLocalModel(ModelChange change, CancellationToken cancellationToken, Boolean blockUI)
en Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.RouteAsync(ModelChange change, CancellationToken cancellationToken, Boolean blockUI)
en Microsoft.PowerBI.Client.Windows.ModelAuthoringHostService.<>c__DisplayClass4_0.<<ModelAuthoringApply>b__1>d.MoveNext()
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder'1.Start[TStateMachine](TStateMachine& stateMachine)
en Microsoft.PowerBI.Client.Windows.ModelAuthoringHostService.<>c__DisplayClass4_0.<ModelAuthoringApply>b__1(CancellationToken cancelToken)
en Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass8_0'1.<<ExecuteAndHandlePromise>b__0>d.MoveNext()
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
en Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass8_0'1.<ExecuteAndHandlePromise>b__0()
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
en System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func'1 asyncFunc)
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
en System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func'1 asyncFunc)
en Microsoft.PowerBI.Client.Windows.ModelAuthoringHostService.<>c__DisplayClass4_0.<ModelAuthoringApply>b__0()
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
en System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
en System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
en System.Delegate.DynamicInvokeImpl(Object[] args)
en System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
en System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
en System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
en System.Windows.Forms.Control.InvokeMarshaledCallbacks()
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
en System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
en System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
en System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
en Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
en Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func'1 showModalFunction)
en Microsoft.PowerBI.Client.Program.<>c__DisplayClass1_0.<Main>b__1()
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
en Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
"AppName":"PBIDesktop","AppVersion":"2.82.5858.441","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Modeling.LoadToReportProgress","Error":"System.Collections.Generic.KeyNotFoundException","MethodDef":"<UpdateImportProgress>b__22_0","ErrorOffset":"42"
