Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError
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. |
7 Replies
- DataVitalizer
Super User
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
Restart the server as in: Power BI server or gateway server?
Regards,
SK.
- DataVitalizer
The datasource server
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.
SantoshKumarMicrosoft Employee
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.Dear SantoshKumar,
What if the issue is always with one table? What would that mean?
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.
