Forum Discussion

WMaia's avatar
WMaia
New Member
5 years ago

Power BI

Good afternoon.
When updating tables in Power BI Pro the program returns the following error.

Error Message:

Internal connection fatal error. Error state: 15, Token : 67

 

Stack Trace:

   em Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)

   em Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

   em Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

   em Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

   em Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

   em Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)

   em Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunkAndCheckIfClosed()

   em 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)

   em Microsoft.OleDb.Serialization.PageReader.ReadChars(Int32 count)

   em Microsoft.OleDb.Serialization.PageReader.ReadArray(String[] values, Int32 offset, Int32 count)

   em Microsoft.OleDb.NullableColumn.Deserialize(PageReader reader)

   em Microsoft.OleDb.Serialization.ColumnsPage.Deserialize(PageReader reader)

   em Microsoft.OleDb.Serialization.OleDbPageReader.Read(ColumnsPage page)

   em Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(IPage page)

   em Microsoft.Mashup.Engine.Interface.Tracing.TracingPageReader.Read(IPage page)

   em Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.ExceptionResolverPageReader.Read(IPage page)

   em Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(IPage page)

   em Microsoft.Mashup.Engine.Interface.Tracing.TracingPageReader.Read(IPage page)

   em Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(IPage page)

   em 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)

 

Stack Trace Message:

Internal connection fatal error. Error state: 15, Token : 67

 

Invocation Stack Trace:

   em Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

   em Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)

   em Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)

   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)

   em 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(Report report, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IQueryServices queryServices, IModelingService modelingService, IUIHost uiHost, LocalizedString title, LoadToModelContext loadToModelContext, IEventAggregationService eventAggregationService)

   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)

   em 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 parameters)

   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 parameter)

   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 parameter)

   em Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(ICommand command, Object parameter)

   em Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter)

   em Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(T parameter)

   em Microsoft.PowerBI.Client.Windows.CommandStoreHostService.<>c__DisplayClass14_0.<Execute>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.<HandleExceptionsWithNestedTasks>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":""}

 

Snapshot Trace Logs:

C:\Users\RCandido\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot6120c3df-9873-4262-b58e-3785b49f3c48.zip

 

Model Default Mode:

Import

 

Model Version:

PowerBI_V3

 

Is Report V3 Models Enabled:

True

 

Performance Trace Logs:

C:\Users\RCandido\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

 

Enabled Preview Features:

PBI_v3ModelsPreview

 

Disabled Preview Features:

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

 

Disabled DirectQuery Options:

TreatHanaAsRelationalSource

 

Cloud:

GlobalCloud

 

PowerBINonFatalError_ErrorDescription:

Microsoft.Mashup.Evaluator.Interface.ErrorException

 

PowerBIUserFeedbackServices_IsReported:

True

 

Formulas:

 

 

section Section1;

 

shared DIM_CALENDARIO_VW = let

    Fonte = Sql.Database("CF-DBSERVER\DW", "DW_CF"),

    dbo_DIM_CALENDARIO_VW = Fonte{[Schema="dbo",Item="DIM_CALENDARIO_VW"]}[Data]

in

    dbo_DIM_CALENDARIO_VW;

 

shared DIM_FILIAL_VW = let

    Fonte = Sql.Database("CF-DBSERVER\DW", "DW_CF"),

    dbo_DIM_FILIAL_VW = Fonte{[Schema="dbo",Item="DIM_FILIAL_VW"]}[Data]

in

    dbo_DIM_FILIAL_VW;

 

shared DIM_CLIENTE_VW = let

    Fonte = Sql.Database("CF-DBSERVER\DW", "DW_CF"),

    dbo_DIM_CLIENTE_VW = Fonte{[Schema="dbo",Item="DIM_CLIENTE_VW"]}[Data]

in

    dbo_DIM_CLIENTE_VW;

 

shared DIM_MOTORISTA_VW = let

    Fonte = Sql.Database("CF-DBSERVER\DW", "DW_CF"),

    dbo_DIM_MOTORISTA_VW = Fonte{[Schema="dbo",Item="DIM_MOTORISTA_VW"]}[Data]

in

    dbo_DIM_MOTORISTA_VW;

 

shared DIM_PRODUTO_VW = let

    Fonte = Sql.Database("CF-DBSERVER\DW", "DW_CF"),

    dbo_DIM_PRODUTO_VW = Fonte{[Schema="dbo",Item="DIM_PRODUTO_VW"]}[Data]

in

    dbo_DIM_PRODUTO_VW;

 

shared FAT_VOLUME_EXPEDIDO_2_ANOS_VW = let

    Fonte = Sql.Database("CF-DBSERVER\DW", "DW_CF"),

    dbo_FAT_VOLUME_EXPEDIDO_2_ANOS_VW = Fonte{[Schema="dbo",Item="FAT_VOLUME_EXPEDIDO_2_ANOS_VW"]}[Data]

in

    dbo_FAT_VOLUME_EXPEDIDO_2_ANOS_VW;

 

shared FAT_ORCAMENTO_COMERCIAL_2_ANOS_VW = let

    Fonte = Sql.Database("CF-DBSERVER\DW", "DW_CF"),

    dbo_FAT_ORCAMENTO_COMERCIAL_2_ANOS_VW = Fonte{[Schema="dbo",Item="FAT_ORCAMENTO_COMERCIAL_2_ANOS_VW"]}[Data]

in

    dbo_FAT_ORCAMENTO_COMERCIAL_2_ANOS_VW;

 

shared #"Base Veículos" = let

    Fonte = Excel.Workbook(File.Contents("\\cfh-fileserver\DataSources\PBI_Transportes\DE_PARA_LOGISTICA.xlsx"), null, true),

    #"Base Veículos_Sheet" = Fonte{[Item="Base Veículos",Kind="Sheet"]}[Data],

    #"Cabeçalhos Promovidos" = Table.PromoteHeaders(#"Base Veículos_Sheet", [PromoteAllScalars=true]),

    #"Tipo Alterado" = Table.TransformColumnTypes(#"Cabeçalhos Promovidos",{{"CHAVE PLACA", type text}, {"MÊS", type date}, {"PLACA", type text}, {"Operação", type text}, {"Família", type text}, {"Modelo", type any}, {"OBS", type text}, {"CUBAGEM", type number}})

in

    #"Tipo Alterado";