Forum Discussion

DarthMall's avatar
DarthMall
Regular Visitor
9 years ago

Error When Trying to Connect

Trying to get data from a SQL database that has the On Premise Gateway installed from PowerBI Desktop and getting the following error:

 

Details: "An error happened while reading data from the provider: 'System.IO.FileLoadException'"

 

Here is the Mashup Container log, as I've read can be of help, although it's not assisting me at all.

 

DataMashup.Trace Error: 24579 : {"Start":"2017-04-04T15:53:34.9939104Z","Action":"EvaluationContainerMain/ExceptionHandler/HandleException","containerID":"1","Exception":"Exception:\r\nExceptionType: System.Threading.AbandonedMutexException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The wait completed due to an abandoned mutex.\r\nStackTrace:\n at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)\r\n at System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean exitContext)\r\n at Microsoft.Mashup.Container.EvaluationContainerMain.WaitForParentExitThread(Object state)\r\n at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)\r\n\r\n\r\n","ProductVersion":"2.44.4675.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":12820,"Tid":3,"Duration":"00:00:00.0000726"}
DataMashup.Trace Error: 24579 : {"Start":"2017-04-04T15:53:34.9939378Z","Action":"EvaluationContainerMain/ExceptionHandler/HandleException","containerID":"1","Exception":"Exception:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Unable to read beyond the end of the stream.\r\nStackTrace:\n at System.IO.BinaryReader.FillBuffer(Int32 numBytes)\r\n at System.IO.BinaryReader.ReadInt32()\r\n at Microsoft.Mashup.Evaluator.MessageSerializer.Deserialize(BinaryReader reader)\r\n at Microsoft.Mashup.Evaluator.StreamMessenger.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.RemoteServiceEnvironment.CreateServiceProxies(IMessenger messenger, IRemoteServiceProxy[]& services)\r\n at Microsoft.Mashup.Evaluator.EvaluationHost.Run()\r\n at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)\r\n\r\n\r\n","ProductVersion":"2.44.4675.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":12820,"Tid":1,"Duration":"00:00:00.0000678"}

3 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee

    Hi DarthMall,

     

    To narrow down the cause of this issue, could you try installing SQL Server Management Studio(SSMS) on the same machine that have Power BI Desktop installed, then use SSMS to connect to the SQL Server and check if it is successful?:smileyhappy:

     

    Regards

    • DarthMall's avatar
      DarthMall
      Regular Visitor

      Hi sorry for the delay, I was away.  

       

      Yes I can connect from the client machine using SSMS

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee

    Hi DarthMall,

     

    From the Mashup Container log you posted above, I notice that you're using an old version of Power BI Desktop(2.44.4675.521). Could you try uninstalling Power BI Desktop first, then installing the latest version(2.45.4704.442 64-bit (April 2017)) of Power BI Desktop to see if it works? (Just in case, please also reinstall the latest version of On Premise Gateway here.) :smileyhappy:

     

    Regards