Forum Discussion
Dataset refresh failure - DM_GWPipeline_Gateway_MashupDataAccessError
Can someone translate this to English, on behalf of a coworker who is not a power bi admin:
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: GL Balance Sheet.
Cluster URI: WABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 0671e40d-a364-4b97-8c8c-f84f5212694e
Request ID: 1882c29b-31ac-4f4e-9a7a-a2967902bea2
Time: 2023-08-15 13:02:55Z
They would like to know what we can do to allow users to see the underlying reason for these meaningless messages. Is it reasonable to share the logs directory with them over the network? Eg:
C:\windows\ServiceProfiles\BuggyPbiService\AppData\Local\Microsoft\On-premises data gateway
It was only possible to find the true underlying reason for this error message by reading the gateway logs. Microsoft needs to make those available to the people who need them. The admins in our environment do not necessarily want to participate in the troubleshooting of every failing dataset-refresh.
7 Replies
- sulleyinozAdvocate II
This might be related to this issue reported a couple of days ago if it used to refresh and has now stopped with no changes.
- dbeavon3Memorable Member
It is impossible to say unless I can dig into the logs.
Unfortunately when I'm using the Power BI service, all I can do is see the message above ("we're sorry something bad happened.").
- dbeavon3Memorable Member
It was only possible to find the true underlying reason for this error message by reading the gateway logs. Microsoft needs to make those available to the people who need them. The admins in our environment do not necessarily want to participate in the troubleshooting of every failing dataset-refresh.
- AleMaldonadoNew Member
la solucion esta en configurar el mismo nivel de privacidad en la puerta de enlace para todos los origenes en el servicio.
Editen las credenciales de origenes de datos y seleccionen el mismo para todos. encontraran las fuentes y la opcio de editar.
Me paso recien y de esa manera lo pude solucionar. Saludos - rico343Frequent Visitor
In our case the logs on the gateway server showed there was not enough space on the disk. Other reports worked fine, but one that is gathering a large amount of data started failing.