Buenas tardes.
Al actualizar tablas en Power BI Pro, el programa devuelve el siguiente error.
Mensaje de error:
Error fatal de conexión interna. Estado de error: 15, Token : 67
Rastreo de pila:
em Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
em Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(canal IMessageChannel, mensaje de mensaje)
em Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
em Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(canal IMessageChannel, mensaje de mensaje)
em Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
em Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](canal IMessageChannel)
en Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunkAndCheckIfClosed()
en Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunk()
em Microsoft.Mashup.Common.ChunkedInputStream.Read(Byte[] buffer, Int32 offset, Int32 count)
em Microsoft.OleDb.Serialization.PageReader.Read(Byte[] buffer, Int32 offset, Int32 count)
en Microsoft.OleDb.Serialization.PageReader.ReadChars(Int32 count)
em Microsoft.OleDb.Serialization.PageReader.ReadArray(String[] values, Int32 offset, Int32 count)
em Microsoft.OleDb.NullableColumn.Deserialize(Lector PageReader)
em Microsoft.OleDb.Serialization.ColumnsPage.Deserialize(Lector De PageReader)
en Microsoft.OleDb.Serialization.OleDbPageReader.Read(página ColumnsPage)
en Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(página IPage)
en Microsoft.Mashup.Engine.Interface.Tracing.TracingPageReader.Read(página IPage)
en Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.ExceptionResolverPageReader.Read(página IPage)
en Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(página IPage)
en Microsoft.Mashup.Engine.Interface.Tracing.TracingPageReader.Read(página IPage)
en Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(página IPage)
en Microsoft.OleDb.Serialization.PageReaderRowset.ReadNextPage()
em Microsoft.OleDb.Serialization.PageReaderRowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hchapter, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)
em Microsoft.OleDb.Rowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hReserved, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)
em Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hReserved, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)
Mensaje de seguimiento de pila:
Error fatal de conexión interna. Estado de error: 15, Token : 67
Seguimiento de pila de invocación:
en Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
em Microsoft.Mashup.Client.UI.Shared.StackTraceInfo.. ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
en Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception y)
em Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
em Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass0_1.<SendAndMarshalExceptions>b__0(Object null)
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.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
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)
en Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
em Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func'1 showModalFunction)
em Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.TryShowDialog(Informe, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IQueryServices queryServices, IModelingService modelingService, IUIHost uiHost, LocalizedString title, LoadToModelContext loadToModelContext, IEventAggregationService eventAregggationService)
em Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass17_0.<TryShowDialogForQueriesInternal>b__0()
em Microsoft.PowerBI.Client.Windows.Report.<>c__DisplayClass56_0'1.<SynchronizeLooselyWithQueries>b__0()
em Microsoft.PowerBI.Client.Windows.Report.<SynchronizeLooselyWithQueriesAsync>d__57'1.MoveNext()
em System.Runtime.CompilerServices.AsyncTaskMethodBuilder'1.Start[TStateMachine](TStateMachine& stateMachine)
en Microsoft.PowerBI.Client.Windows.Report.SynchronizeLooselyWithQueriesAsync[T](Func'1 getTask)
em Microsoft.PowerBI.Client.Windows.Report.SynchronizeLooselyWithQueries[T](Func'1 action)
em Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.RefreshAllQueries(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, RefreshAllQueriesParameters parámetros)
em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
em Microsoft.Practices.Prism.Commands.DelegateCommandBase.<>c__DisplayClass4_0.<.ctor>b__0(Object arg)
em Microsoft.Practices.Prism.Commands.DelegateCommandBase.<Execute>d__10.MoveNext()
em System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
em Microsoft.Practices.Prism.Commands.DelegateCommandBase.Execute(Object parámetro)
em Microsoft.Practices.Prism.Commands.DelegateCommand'1.<Execute>d__5.MoveNext()
em System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
em Microsoft.Practices.Prism.Commands.DelegateCommand'1.Execute(T parámetro)
em Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand'1.Execute(ICommand command, Object parameter)
em Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parámetro)
em Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand'1.Execute(T parámetro)
em Microsoft.PowerBI.Client.Windows.CommandStoreHostService.<>c__DisplayClass14_0.<Ejecutar>b__0()
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.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
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.WindowManager.ShowModal[T](T dialog, Func'1 showModalFunction)
em Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleceptionsWithNestedTasks>b__0()
em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
em Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
"AppName":"PBIDesktop","AppVersion":"2.87.1061.0","ModuleName":"","Component":"","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Evaluator.Interface.ErrorException","MethodDef":"ErrorOffset".
Registros de seguimiento de instantáneas:
C:-Usuarios-RCandido-AppData-Local-Microsoft-Power BI Desktop-FrownSnapShot6120c3df-9873-4262-b58e-3785b49f3c48.zip
Modo predeterminado del modelo:
Importación
Versión del modelo:
PowerBI_V3
Está habilitado el informe de modelos V3:
Verdad
Registros de seguimiento de rendimiento:
C:-Usuarios-RCandido-AppData-Local-Microsoft-Power BI Desktop-PerformanceTraces.zip
Funciones de vista previa habilitadas:
PBI_v3ModelsPreview
Funciones de vista previa desactivadas:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList
Opciones de DirectQuery deshabilitadas:
TreatHanaAsRelationalSource
Nube:
GlobalCloud
PowerBINonFatalError_ErrorDescription:
Microsoft.Mashup.Evaluator.Interface.ErrorException
PowerBIUserFeedbackServices_IsReported:
Verdad
Fórmulas:
sección Sección1;
compartido DIM_CALENDARIO_VW - dejar que
Origen: Sql.Database("CF-DBSERVER-DW", "DW_CF"),
dbo_DIM_CALENDARIO_VW de fuentes [Esquema"dbo",Item"DIM_CALENDARIO_VW"]-[Datos]
En
dbo_DIM_CALENDARIO_VW;
compartido DIM_FILIAL_VW - dejar que
Origen: Sql.Database("CF-DBSERVER-DW", "DW_CF"),
dbo_DIM_FILIAL_VW de fuentes [Esquema"dbo",Artículo"DIM_FILIAL_VW"]-[Datos]
En
dbo_DIM_FILIAL_VW;
compartido DIM_CLIENTE_VW - dejar que
Origen: Sql.Database("CF-DBSERVER-DW", "DW_CF"),
dbo_DIM_CLIENTE_VW de fuentes [Esquema"dbo",Artículo"DIM_CLIENTE_VW"]-[Datos]
En
dbo_DIM_CLIENTE_VW;
compartido DIM_MOTORISTA_VW - dejar que
Origen: Sql.Database("CF-DBSERVER-DW", "DW_CF"),
dbo_DIM_MOTORISTA_VW de fuentes [Esquema"dbo",Artículo"DIM_MOTORISTA_VW"]-[Datos]
En
dbo_DIM_MOTORISTA_VW;
compartido DIM_PRODUTO_VW - dejar que
Origen: Sql.Database("CF-DBSERVER-DW", "DW_CF"),
dbo_DIM_PRODUTO_VW de fuentes [Esquema"dbo",Item"DIM_PRODUTO_VW"]-[Datos]
En
dbo_DIM_PRODUTO_VW;
compartido FAT_VOLUME_EXPEDIDO_2_ANOS_VW - dejar que
Origen: Sql.Database("CF-DBSERVER-DW", "DW_CF"),
dbo_FAT_VOLUME_EXPEDIDO_2_ANOS_VW de fuentes [Esquema"dbo",Artículo"FAT_VOLUME_EXPEDIDO_2_ANOS_VW"]-[Datos]
En
dbo_FAT_VOLUME_EXPEDIDO_2_ANOS_VW;
compartido FAT_ORCAMENTO_COMERCIAL_2_ANOS_VW - dejar que
Origen: Sql.Database("CF-DBSERVER-DW", "DW_CF"),
dbo_FAT_ORCAMENTO_COMERCIAL_2_ANOS_VW de fuentes [Esquema"dbo",Artículo"FAT_ORCAMENTO_COMERCIAL_2_ANOS_VW"]-[Datos]
En
dbo_FAT_ORCAMENTO_COMERCIAL_2_ANOS_VW;
compartido "Vehículos base" - dejar que
Fonte á Excel.Workbook(File.Contents("-cfh-fileserver-DataSources-PBI_Transportes-DE_PARA_LOGISTICA.xlsx"), null, true),
"Base Veículos_Sheet" - Fuente ,[Elemento"Vehículos base",Kind"Sheet"]-[Fecha],
"Encabezados Promocionados" - Table.PromoteHeaders(-"Base Veículos_Sheet", [PromoteAllScalars-true]),
"Tipo cambiado" - Table.TransformColumnTypes('Encabezados promocionados",''KEY PLATE'', escriba text', ''MONTH', ''MONTH', '
En
"Tipo cambiado";
