cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

Status: New
Comments
Community Support

@SandhyaS ,

 

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

Regular Visitor

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

Community Support

@SandhyaS ,

 

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?

Capture.PNG 

Regards,

Jimmy Tao