Skip to main content
cancel
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

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?