Cannot load MySql data into Power BI Desktop

[JohnCrn]

Hi Everyone,

i'm evaluating Power BI and would like to work on some data from MySQL. The MySQL DB is hosted in AWS. I can connect to the MySQL repo on my dev machine via MySQL Workbench, so the connection between the two systems should be fine.

Using Power BI Desktop I can discover the MySQL instance I'm after and select tables I'd like to import. However the Preview function for the data never seems to work (the evaluating wait message is displayed) and loading the data doesn't seem to get me anywhere. I can watch the Load window for hours...

Note that task manager doesn't seem to think much is going on either. I have enabled tracing and here are some of the logs. Only thing that pops out at me is the filenotfound exceptions. I see plenty of IDX files being created.

DataMashup.Trace Information: 24579 : {"Start":"2016-03-07T04:33:05.0659168Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","Exception":"Exception:\r\nExceptionType: System.IO.FileNotFoundException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Could not find file 'C:\\Users\\jcrnjanin\\AppData\\Local\\Microsoft\\Power BI Desktop\\Cache\\Index\\3560D3FF83A52711.idx'.\r\nStackTrace:\n   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)\r\n   at Microsoft.Mashup.EngineHost.Services.DiskPersistentCache.PersistentDictionary.<>c__DisplayClass24.<ReadBucket>b__23()\r\n   at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.<>c__DisplayClass4.<IgnoringAccessExceptions>b__3()\r\n   at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, Nullable`1 activityId, T& result, Exception& accessException)\r\n\r\n\r\n","ProductVersion":"2.32.4307.522 (PBIDesktop)","ActivityId":"f54ae664-85aa-41ce-8818-dbe0a4d849f5","Process":"Microsoft.Mashup.Container.NetFX40","Pid":984,"Tid":1,"Duration":"00:00:00.0016623"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-07T04:33:05.0989157Z","Action":"Engine/IO/Db/MySQL/RunWithRetry","ProductVersion":"2.32.4307.522 (PBIDesktop)","ActivityId":"f54ae664-85aa-41ce-8818-dbe0a4d849f5","Process":"Microsoft.Mashup.Container.NetFX40","Pid":984,"Tid":1,"Duration":"00:00:00.3987591"}

DataMashup.Trace Warning: 24579 : {"Start":"2016-03-07T04:33:15.2238950Z","Action":"ErrorTranslatingMessenger/Read","Exception":"Exception:\r\nExceptionType: System.InvalidOperationException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Error reading from or writing to stream.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.StreamMessenger.Read()\r\n at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()\r\n\r\n\r\n","ProductVersion":"2.32.4307.522 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":7080,"Tid":29,"Duration":"00:00:00.0001495"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-03-07T04:33:15.2241652Z","Action":"ErrorTranslatingMessenger/Read","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Evaluator.Interface.ErrorException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Container exited unexpectedly with code 0x00000000.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()\r\n at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()\r\n\r\n\r\n","ProductVersion":"2.32.4307.522 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":7080,"Tid":29,"Duration":"00:00:00.0001131"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-03-07T04:33:15.2238221Z","Action":"RemoteServiceEnvironment/DisposeServiceStubs","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Evaluator.Interface.ErrorException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Container exited unexpectedly with code 0x00000000.\r\nUsed features: (none).\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()\r\n at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)\r\n at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()\r\n at Microsoft.Mashup.Evaluator.Interface.IMessengerExtensions.WaitFor[T](IMessenger messenger, Action`2 handler)\r\n at Microsoft.Mashup.Evaluator.Interface.IMessengerExtensions.WaitFor[T](IMessenger messenger)\r\n at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IHostTrace trace, Action action)\r\n\r\nInnerException\r\nException:\r\nExceptionType: Microsoft.Mashup.Evaluator.Interface.ErrorException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Container exited unexpectedly with code 0x00000000.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()\r\n at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.32.4307.522 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":7080,"Tid":29,"Duration":"00:00:00.0006327"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-07T04:33:15.2238077Z","Action":"RemoteEvaluationContainerFactory/Container/Dispose","ProductVersion":"2.32.4307.522 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":7080,"Tid":29,"Duration":"00:00:00.0006768"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-03-07T04:32:49.0622727Z","Action":"PackagePartitionAnalysisInfo/SetPreviewValue","Exception":"Exception:\r\nExceptionType: System.OperationCanceledException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Evaluation was canceled.\r\nStackTrace:\n   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.HandleException(Exception exception, Boolean disposing)\r\n   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)\r\n   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()\r\n   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)\r\n\r\n\r\n","ProductVersion":"2.32.4307.522 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":7080,"Tid":29,"Duration":"00:00:26.1631228"}

Thanks for your help!

[JohnCrn · Accepted solution]

After hours of waiting the Load completed. So nothing wrong just very slow.

Would help to have more visual feedback to know that things are progressing.