Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Error message: DM_GWPipeline_Gateway_MashupDataAccessError

Hi there,

 

when I update the dashboard in the desktop version, I have no ptoblem. When I try to update in Service, this error appears. The mentioned Table in the Error "Lagerort_AK" is a .txt file. I´m loading 5 tables from sharepoint Excel files in the dashboard and that seems to be no problem. what could be the problem here? ("Lagerort_AK" also is an appended query which at first loads the .txt file and is then combined with another SQLQuery. Could this be the problem?)

 

Furthermore in all other hostet dashboards there is no problem accessing the sharepoint files using the same gateway

 

{"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":"SharePoint: Request failed: The remote name could not be resolved: 'basf.sharepoint.com'"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://basf.sharepoint.com/teams/MI-ServiceHub"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Lagerort_AK.
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I stopped importing the .txt file and instead used the data input in PowerQuery. Now the append query works fine. This only works because the .txt is a static file that normally never changes. Another Solution was not found actually or what was the exact root cause of the failure

4 Replies