Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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>
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.
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>
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.