Forum Discussion

Sillsree15's avatar
Sillsree15
Frequent Visitor
1 year ago

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError"

HI Team ,

While refreshing the data from gatway it is throughing error below ,

 

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":"ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC]
General error;414 user is forced to change [CredentialRemoved]"}},
{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},
{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},
{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=GBP_HANA_ODBC"}},
{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":
"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},
{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":
{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: SalesOffice_LookUp.
Cluster URI: WABI-NORTH-EUROPE-F-PRIMARY-redirect.analysis.windows.net
Activity ID: 62c00bde-b023-4a5c-882a-26026dea8125
Request ID: ecda555a-4a92-5559-359a-6865e2a3d56c
Time: 2024-09-10 10:38:12Z

Could any please help in this issue .

 

Thanks in advance 

Sreeni

 

Need Help

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    1 year ago

    Hi. A mashup error usually means that the Power Query executed for the semantic model has an error. Ir order to capture the error, the best approach would be openening the pbix file at the same server of the gateway and refresh it. The refresh will show a better error details to understand the problem.

    I hope that helps,

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Sillsree15 ,

    II haven't heard back from you in a while and wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
    Looking forward to your reply!