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

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_timeout, net_write_timeout and didn't work.

erro_powerbi.JPG

5 REPLIES 5
luizgoka Frequent Visitor
Frequent Visitor

Re: Cannot connect to the mashup data source

Anyone knows how to solve it?
luizgoka Frequent Visitor
Frequent Visitor

Re: Cannot connect to the mashup data source

Can any admin help me?

luizgoka Frequent Visitor
Frequent Visitor

Re: Cannot connect to the mashup data source

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>

luizgoka Frequent Visitor
Frequent Visitor

Re: Cannot connect to the mashup data source

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>

Highlighted
fhendrick Frequent Visitor
Frequent Visitor

Re: Cannot connect to the mashup data source

Hi,

 

I had a call with Microsoft, they asked me to put privacy level to PRIVATE in the desktop, re-publish, then set privacy = PRIVATE in the PBI online service too (in the gateway settings we're using).

 

It solved the issue.

 

Cheers,

 

F.