cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JohnCrn Frequent Visitor
Frequent Visitor

Cannot load MySql data into Power BI Desktop

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...

pbi.PNG

 

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
JohnCrn Frequent Visitor
Frequent Visitor

Re: Cannot load MySql data into Power BI Desktop

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.

View solution in original post

1 REPLY 1
JohnCrn Frequent Visitor
Frequent Visitor

Re: Cannot load MySql data into Power BI Desktop

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.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,571)