Dataset refresh fine in Desktop, but not in Service

[Anonymous]

Hi

I have gone through the similar topics, but haven't found an answer to this. 

I have a report that refreshes fine in Desktop, but not in Service. It uses a variety of data sources which all works fine in other reports. The only difference between this and other reports is that is has an additional DirectQuery connection. 

This is the errore message. Thanks in advance for any help!

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"MySQL: Fatal error encountered during data read."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"94.237.84.175:3307;eplehuset"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Fatal error encountered during data read."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: FACT Ordre.

[arvindsingh802 · Accepted solution]

I have replied to you other thread, you can close this and follow one thread

If this post helps, then please consider Accept it as the solution and give it a thumbs up