issue with gateway and auto refresh not happening- fix needed immediately

[Anonymous]

Hi ,

In powerbi service report is not getting auto refreshed as there seems to be issue to powerBI gateway. Please provide fix/resolution ASAP.

error:

{"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":"<pi>MySQL: Fatal error encountered during data read.</pi>"}},{"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":"1xx;EUROPE"}},{"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: EUROPE vw_Headcount_Base.

[v-yuta-msft]

@Anonymous ,

Which data source are you connecting? Make sure power bi data gateway has been updated to the latest version and the credentails are still valid.

Regards,

Jimmy Tao

[Anonymous]

latest version of POWERBI gateway installed and data sources are valid and no issue with connection but still issue with refresh on service.

[v-yuta-msft]

@Anonymous ,

So the data source is an online source, right? Could clarify which data source are you connecting and have you checked the refresh history as below?

 

Regards,

Jimmy Tao