Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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.EnterpriseGateway590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=41, err=MashupCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway8B21C03B [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.EnterpriseGateway9123FFC4 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <ccon>-2147467259</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway9123FFC4 [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.EnterpriseGateway9123FFC4 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingHResult = <ccon>-2147467259</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.DataSourceKind = <ccon>Web</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway9123FFC4 [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.EnterpriseGateway9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.Reason = <ccon>CredentialMissing</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway9123FFC4 [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.EnterpriseGateway9123FFC4 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.MashupSecurityException.Reason = <ccon>CredentialMissing</ccon>
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=42, err=MashupDataAccessCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=43, err=MashupDataAccessCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2023-12-14T17:12:15.5212655Z DM.EnterpriseGateway4C1EF73E [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

1 Reply

  • aj1973's avatar
    aj1973
    Community Champion

    Hi Anonymous 

    May be you need to change the Authentication Kind or method