Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
luizgoka
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

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>

Anonymous
Not applicable

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.

luizgoka
Frequent Visitor

Anyone knows how to solve it?

Can any admin help me?

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>

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors