Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
luizgoka
Frequent Visitor

Cannot connect to the mashup data source

‎08-20-2018 08:56 PM

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

Labels:
Message 1 of 6
4,451 Views
5 REPLIES 5
luizgoka
Frequent Visitor

‎08-21-2018 03:41 PM

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>

Message 5 of 6
4,412 Views
0
Anonymous
Not applicable
In response to luizgoka

‎12-05-2018 12:35 PM

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.

Message 6 of 6
4,023 Views
luizgoka
Frequent Visitor

‎08-21-2018 03:41 AM
Anyone knows how to solve it?
Message 2 of 6
4,437 Views
0
luizgoka
Frequent Visitor
In response to luizgoka

‎08-21-2018 12:11 PM

Can any admin help me?

Message 3 of 6
4,424 Views
0
luizgoka
Frequent Visitor
In response to luizgoka

‎08-21-2018 03:33 PM

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>

Message 4 of 6
4,412 Views
0

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

View All
Top Solution Authors
View All