Forum Discussion

luizgoka's avatar
luizgoka
Frequent Visitor
8 years ago

Cannot connect to the mashup data source

Hi guys,   So, my problem is that I can refresh data correctly on Power BI Desktop but when I try to refresh on Power BI Service I got the error in image below: - I changed the variables net_read_...
Need Help
luizgoka's avatar
luizgoka
Frequent Visitor
8 years ago
Anyone knows how to solve it?
luizgoka's avatar
luizgoka
Frequent Visitor
8 years ago

Can any admin help me?

  • luizgoka's avatar
    luizgoka
    Frequent Visitor
    8 years ago

    DM.PersonalGateway Error: 0 : 2018-08-21T22:28:05.5447171Z DM.PersonalGateway 5ac4ea91-06f9-4131-beda-b62f784a4462 ca91a637-6ebc-e1b7-c11e-271c0f7a5ca4 MGPS d940cd9e-09e6-d93e-fd53-872c9aca4ae4 F098D97E [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupValueException (0x80004005): MySQL: Fatal error encountered during data read.
    at Microsoft.OleDb.Serialization.PageReaderDataReader.Read()
    at Microsoft.Data.Mashup.MashupReader.Read()
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.AdoBinaryWriterSerializer.<Read>d__11.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.AdoBinaryWriterSerializer.<Serialize>d__10.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<SerializeAdoQueryResponse>d__15.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<SerializeImpl>d__14.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<>c__DisplayClass13_0.<<Serialize>b__0>d.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__5.MoveNext()
    DM.PersonalGateway Error: 0 : 2018-08-21T22:28:05.5583065Z DM.PersonalGateway 5ac4ea91-06f9-4131-beda-b62f784a4462 ca91a637-6ebc-e1b7-c11e-271c0f7a5ca4 MGPS d940cd9e-09e6-d93e-fd53-872c9aca4ae4 14CDA3E0 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=214, err=MashupValueException, rootcauseErrorEventId=0)
    DM.PersonalGateway Error: 0 : 2018-08-21T22:28:05.5583065Z DM.PersonalGateway 1041df16-9fa3-481c-b1d3-613a8a1f7155 ca91a637-6ebc-e1b7-c11e-271c0f7a5ca4 MDSR d940cd9e-09e6-d93e-fd53-872c9aca4ae4 959E5FDF [DM.GatewayCore] Error serializing response: Microsoft.Data.Mashup.MashupValueException (0x80004005): MySQL: Fatal error encountered during data read.
    at Microsoft.OleDb.Serialization.PageReaderDataReader.Read()
    at Microsoft.Data.Mashup.MashupReader.Read()
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.AdoBinaryWriterSerializer.<Read>d__11.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.AdoBinaryWriterSerializer.<Serialize>d__10.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<SerializeAdoQueryResponse>d__15.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<SerializeImpl>d__14.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<>c__DisplayClass13_0.<<Serialize>b__0>d.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__5.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<Serialize>d__13.MoveNext()
    DM.PersonalGateway Error: 0 : 2018-08-21T22:28:05.5951900Z DM.PersonalGateway 1041df16-9fa3-481c-b1d3-613a8a1f7155 ca91a637-6ebc-e1b7-c11e-271c0f7a5ca4 MDSR d940cd9e-09e6-d93e-fd53-872c9aca4ae4 727CA6CB [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error. Reason: .; ErrorShortName: MashupDataAccessValueException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259,HResult=-2147467259]
    DM.PersonalGateway Error: 0 : 2018-08-21T22:28:05.5951900Z DM.PersonalGateway 1041df16-9fa3-481c-b1d3-613a8a1f7155 ca91a637-6ebc-e1b7-c11e-271c0f7a5ca4 MDSR d940cd9e-09e6-d93e-fd53-872c9aca4ae4 8AA61592 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <pi>-2147467259</pi>
    DM.PersonalGateway Error: 0 : 2018-08-21T22:28:05.5951900Z DM.PersonalGateway 1041df16-9fa3-481c-b1d3-613a8a1f7155 ca91a637-6ebc-e1b7-c11e-271c0f7a5ca4 MDSR d940cd9e-09e6-d93e-fd53-872c9aca4ae4 082653A2 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <pi><pi>MySQL: Fatal error encountered during data read.</pi></pi>
    DM.PersonalGateway Error: 0 : 2018-08-21T22:28:05.5951900Z DM.PersonalGateway 1041df16-9fa3-481c-b1d3-613a8a1f7155 ca91a637-6ebc-e1b7-c11e-271c0f7a5ca4 MDSR d940cd9e-09e6-d93e-fd53-872c9aca4ae4 6A5E25DC [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingHResult = <pi>-2147467259</pi>
    DM.PersonalGateway Error: 0 : 2018-08-21T22:28:05.5951900Z DM.PersonalGateway 1041df16-9fa3-481c-b1d3-613a8a1f7155 ca91a637-6ebc-e1b7-c11e-271c0f7a5ca4 MDSR d940cd9e-09e6-d93e-fd53-872c9aca4ae4 7BA84428 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.Reason = <pi>DataSource.Error</pi>