DM_GWPipeline_Gateway_MashupDataAccessError

[swaroopjk]

I am getting an error while doing a scheduled refresh. I can do arefresh in the PBI desktop and upload the upated report but cannot refresh does not work when its scheduled. Please advise:

Data source 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":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: Merge1.

[Fabiel-Valardao]

Estou com esse problema à dias já atualizei a ver~soa do gateway e mesmo ele estando on line ao atualizar a tabela gera um erro como se o gateway estivesse offline. 

"Requested on,Nome do fluxo de dados,Status de atualização de fluxo de dados,Nome da tabela,Nome da partição,Atualizar o status,Hora de início,Hora de término,Duração,Linhas processadas,Bytes processados (KB),Confirmação máxima (KB),Tempo do Processador,Tempo de espera,Mecanismo de computação,Erro,  2025-05-19 13:02:27,MT1-2274,Falhou,CONSULTA_TICKET_COMPLETO_VIEW,N/D,Falhou,2025-05-19 13:02:27,2025-05-19 13:02:57,00:00:30.2630,N/D,N/D,N/D,N/D,N/D,N/D,Error: Encountered user gateway exception: '[GatewayPipelineErrorCode]=DM_GWPipeline_Client_GatewayUnreachable [ErrorShortName]=GatewayUnreachableException/CommunicationObjectFaultedException[HResult=-2146233087] [ExceptionErrorShortName]=GatewayUnreachableException'. RootActivityId = 9b675bd3-e252-4b02-a091-8970aacb9ce8.Param1 = [GatewayPipelineErrorCode]=DM_GWPipeline_Client_GatewayUnreachable [ErrorShortName]=GatewayUnreachableException/CommunicationObjectFaultedException[HResult=-2146233087] [ExceptionErrorShortName]=GatewayUnreachableException Request ID: 3bba2e60-dffc-8ff7-8450-28f0a4c73b22.

[SantoshKumar]

@swaroopjk 
Few things you need to figure out here:
1. Does the issue is always with One Table or you are seeing different table name for every refresh error?
2. If it is multiple tables then there could be timeout issue? In general when you do manual refresh, you will not see it. so increase the timeout value for the tables.

[SantiNarv]

Dear SantoshKumar,

What if the issue is always with one table? What would that mean?

[swaroopjk]

The data is placed at a central location in sharepoint and i am not sure how do I get it restarted. The issue is not resolved yet.

[DataVitalizer]

Hi @swaroopjk 

Could you restart the gateway locally then make sure it's enabled online, otherwise try these 2 options:

1. Restart the whole server and give a check the online refresh

2. If nothing worked, reinstall the gateway

Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated

[swaroopjk]

Restart the server as in: Power BI server or gateway server?

Regards,

SK.

[DataVitalizer]

The datasource server