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"...}}} Table: Lagerort_AK. |
