Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reports do not refresh

We are having problems with 40% of our reports where they don't refresh. The error is "DM_GWPipeline_Gateway_MashupDataAccessError". We have already refreshed the DW server but it didn't work. The full error is bellow, only changing the name of the tables.

 

An error occurred while processing the data in the dataset.
Falha na atualização:

Falha na atualização do Fortali - Cargas Abertas.
Detalhes da falha: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"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":"<ccon>Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon><ip>192.168.1.18</ip>;bi_rbfortali</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: dimTempo.

Status: Investigating

Hi  @TI_RB ,

 


Would you mind providing more details? For example, the data source you are using and the connection mode? If it uses a gateway, please make sure your gateway is up to date

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi  @TI_RB ,

 


Would you mind providing more details? For example, the data source you are using and the connection mode? If it uses a gateway, please make sure your gateway is up to date

 

Best regards.
Community Support Team_Caitlyn

TI_RB
Frequent Visitor

@v-xiaoyan-msft , we're using a gateway, personal mode. Our data source is a SQL dw. Does this help?