data refresh error from mysql

[arturocastillo]

Hello,

I have an error when I try to refresh data for my report. The immage of the error is the follow one:

The detail of message is:

Feedback Type:
Frown (Error)

Timestamp:
2017-08-25T17:56:50.3164193Z

Local Time:
2017-08-25T12:56:50.3164193-05:00

Product Version:
2.49.4831.521 (PBIDesktop) (x64)

Release:
August 2017

IE Version:
11.1593.14393.0

OS Version:
Microsoft Windows NT 10.0.14393.0 (x64 es-ES)

CLR Version:
4.6.2. or later [Release Number = 394802]

Workbook Package Info:
1* - es-PE, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
418 MB

Private Memory:
320 MB

Peak Virtual Memory:
33.9 GB

Error Message:
El contenedor terminó inesperadamente con el código 0xC0000005.
Características usadas: (ninguno).

Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: El contenedor terminó inesperadamente con el código 0xC0000005.
Características usadas: (ninguno). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: El contenedor terminó inesperadamente con el código 0xC0000005.
Características usadas: (ninguno). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: El contenedor terminó inesperadamente con el código 0xC0000005.
Características usadas: (ninguno). ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: El contenedor terminó inesperadamente con el código 0xC0000005.
   en Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
   en Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
   --- Fin del seguimiento de la pila de la excepción interna ---
   en Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
   en Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
   en Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
   en Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
   en Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunkAndCheckIfClosed()
   en Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunk()
   en Microsoft.Mashup.Evaluator.ChunkedInputStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   en System.IO.BinaryReader.FillBuffer(Int32 numBytes)
   en System.IO.BinaryReader.ReadInt32()
   en Microsoft.Mashup.Evaluator.ITableSourceSerializationExtensions.ReadITableSource(BinaryReader reader)
   en Microsoft.Mashup.Evaluator.RemotePageReader.CreateProxy(IEngineHost engineHost, IMessageChannel channel, ExceptionHandler exceptionHandler)
   en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.DataReaderSourceRemoteEvaluation.GetResult(Boolean enableFirewall)
   en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
   --- Fin del seguimiento de la pila de la excepción interna ---
   en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryCompleteWithException(Exception exception)
   en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
   en Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
   en Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)
   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.Threading.ThreadHelper.ThreadStart(Object obj)
   --- Fin del seguimiento de la pila de la excepción interna ---

Server stack trace:


Exception rethrown at [0]:
   en Microsoft.OleDb.AsyncResult`1.get_Value()
   en Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.OnEvaluationComplete(AsyncResult`1 result)

Exception rethrown at [1]:
   en Microsoft.OleDb.AsyncResult`1.get_Value()
   en Microsoft.Mashup.OleDbProvider.MashupRowset.get__Rowset()
   en Microsoft.OleDb.Rowset.Microsoft.OleDb.IRowset.AddRefRows(DBCOUNTITEM cRows, HROW* nativeRows, UInt32* nativeRefCounts, DBROWSTATUS* nativeRowStatus)
   en Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IRowset.AddRefRows(DBCOUNTITEM cRows, HROW* nativeRows, UInt32* nativeRefCounts, DBROWSTATUS* nativeRowStatus)

Invocation Stack Trace:
   en Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   en Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   en Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
   en Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
   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.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
   en Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog.FloatingDialog.ShowDialogWithTimeout(IWin32Window owner, Nullable`1 showTimeout)
   en Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.StartEvaluationAndShowDialog(IEnumerable`1 queriesToLoad, Nullable`1 showTimeout, Boolean requireFullDataRefresh)
   en Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.TryShowDialogForQueries(Report report, IWin32Window ownerWindow, WindowsHost windowsHost, IQueryServices queryServices, IEnumerable`1 queriesToLoad, String loadReason, LocalizedString title, Boolean requireFullDataRefresh)
   en Microsoft.PowerBI.Client.Windows.MainWindow.RefreshAllQueries(String refreshReason)
   en Microsoft.PowerBI.Client.Windows.Ribbon.ApplicationRibbonCommandActionHandler.HandleCommand(UInt32 commandId)
   en Microsoft.Mashup.Client.Windows.UICommands.CommandActionHandlerBase.CommandAction(UInt32 commandId)
   en Microsoft.Mashup.Client.Windows.Ribbon.RibbonCommandHandler.Execute(UInt32 commandId, CommandExecutionVerb verb, PropertyKeyRef keyRef, PropVariantRef currentValue, IUISimplePropertySet commandExecutionProperties)
   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.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
   en Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
   en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
   en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   en Microsoft.PowerBI.Client.Program.Main(String[] args)


User ID:
982f2272-ba67-4e7c-900b-abd75153ba83

Session ID:
46d376f8-8f11-40e1-b780-90a4c1775e31

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Dell\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot122336333.zip

Performance Trace Logs:
C:\Users\Dell\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled

Disabled Preview Features:
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

Formulas:


section Section1;

shared #"test reporte_a1" = let
    Origen = MySQL.Database("localhost", "pedidos", [ReturnSingleDatabase=true]),
    pedidos_reporte_a1_2017 = Origen{[Schema="pedidos",Item="reporte_a1_2017"]}[Data],
    #"Tipo cambiado" = Table.TransformColumnTypes(pedidos_reporte_a1_2017,{{"fecha_registro", type date}, {"fecha_liquidacion", type date}}),
    #"Filas ordenadas" = Table.Sort(#"Tipo cambiado",{{"est_orig", Order.Descending}}),
    #"Texto en mayúsculas" = Table.TransformColumns(#"Filas ordenadas",{{"armario", Text.Upper}}),
    #"Texto limpio" = Table.TransformColumns(#"Texto en mayúsculas",{{"armario", Text.Clean}}),
    #"Texto recortado" = Table.TransformColumns(#"Texto limpio",{{"armario", Text.Trim}}),
    #"Tipo cambiado1" = Table.TransformColumnTypes(#"Texto recortado",{{"fecha", type date}})
in
    #"Tipo cambiado1";

[v-qiuyu-msft · Accepted solution]

Hi @arturocastillo,

Please go to C:\Users\username\AppData\Local\Microsoft\Power BI Desktop\Cache and delete all files found there. Then restart the Power BI desktop to refresh again.

If issue persists, please enable desktop trace log, repeat the steps to reproduce the issue, share log files with us (please share log in English language, you can try the English desktop).

Best Regards,
QiuyunYu