Missing or invalid credentials for data source. Reason = 'CredentialMissing'

[Mofizur]

Hi All,

I have setup a new on-premise data gateway and followed MS Guide

to configure proxy to connect to teh outside world. It seems everything is workign as expected with regards to connectivity.

Proxy configuration : Proxy settings match for all Gateway process configurations.

Overall Results : 48/48 tests succeeded.

Conneciton to Share Point Online as a standalone works fine too. However in combinaiton with HANA when I am trying to do Get Data from Web it is giving me below error even though the crendetials are correct - It asks me to sign and after signing it it again goes back to teh prompt and finaly it fails . My Data gateway is running with DOmian Account only. ANy idea?

DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=41, err=MashupCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	8B21C03B [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessCredentialException: Credentials are required to connect to the Web source. (Source at
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	9123FFC4 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <ccon>-2147467259</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	9123FFC4 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <ccon>[ccon]Credentials are required to connect to the Web source. (Source at
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	9123FFC4 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingHResult = <ccon>-2147467259</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.DataSourceKind = <ccon>Web</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.DataSourcePath = <ccon>https://spo-global.
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.Reason = <ccon>CredentialMissing</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.MashupSecurityException.DataSources = <ccon>[{"kind":"Web","path":"
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.MashupSecurityException.Reason = <ccon>CredentialMissing</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=42, err=MashupDataAccessCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=43, err=MashupDataAccessCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway	4C1EF73E [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessCredentialException: Credentials are required to connect to the Web source. (Source at  Thanks, Mofizur

[aj1973]

Hi @Mofizur 

May be you need to change the Authentication Kind or method