Encountered user gateway exception. The credentials provided for the PowerBI source are invalid
Hello ,
Any Updates on this error ? marcritchie Anonymous
I am getting a similar error when trying Incremental Refresh on a DataFlow . The Data access is through a Gateway and the underlying Data Source is a DB2 Database. Refresh is throwing an Unauthorized Access error while the Gateway Connection is Active and the Credentials are Valid.
Any artifact without Incremental Refresh works without Issues from the same Gateway. Could this be triggered by Data Type mismatch while Query Folding ? DB2 does not have Date/Time and its Datatype is TimeStamp ? < I am just guessing ... but still why a Credential error ? >
Any update is much appreciated
I am including the Sections of the error message for your review
------------------------- Error Message -------------------------------
Requested on,Dataflow name,Dataflow refresh status,Table name,Partition name,Refresh status,Start time,End time,Duration,Rows processed,Bytes processed (KB),Max commit (KB),Processor Time,Wait time,Compute engine,Error,
2023-07-14 12:18:28,FT_Test_DF,Failed,Query,NA,Failed,2023-07-14 12:18:28,2023-07-14 12:18:29,00:00:01.7540,NA,NA,NA,NA,NA,NA,Error: Encountered user gateway exception: '<ccon>The credentials provided for the DB2 source are invalid. (Source at Server:Port;DB.)</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>The credentials provided for the DB2 source are invalid. (Source at Server:Port;DB.)</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.CredentialError.DataSourceKind]=DB2 [Microsoft.Data.Mashup.CredentialError.DataSourcePath]=Server:Port;DB [Microsoft.Data.Mashup.CredentialError.Reason]=AccessUnauthorized [Microsoft.Data.Mashup.MashupSecurityException.DataSources]=[{"kind":"DB2" "path":"Server:Port;DB"}] [Microsoft.Data.Mashup.MashupSecurityException.Reason]=AccessUnauthorized [InnerType]=MashupCredentialException The credentials provided for the DB2 source are invalid. (Source at Server:Port;DB.) [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_InvalidConnectionCredentials [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=119xxxx]/MashupDataAccessCredentialException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupCredentialException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=119xxxx]'. RootActivityId = b6b9e7ab-244f-4b09-8e86-0f3b4b2ca5b1.Param1 = <ccon>The credentials provided for the DB2 source are invalid. (Source at Server:Port;DB.)</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>The credentials provided for the DB2 source are invalid. (Source at Server:Port;DB.)</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.CredentialError.DataSourceKind]=DB2 [Microsoft.Data.Mashup.CredentialError.DataSourcePath]=Server:Port;DB [Microsoft.Data.Mashup.CredentialError.Reason]=AccessUnauthorized [Microsoft.Data.Mashup.MashupSecurityException.DataSources]=[{"kind":"DB2" "path":"Server:Port;DB"}] [Microsoft.Data.Mashup.MashupSecurityException.Reason]=AccessUnauthorized [InnerType]=MashupCredentialException The credentials provided for the DB2 source are invalid. (Source at Server:Port;DB.) [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_InvalidConnectionCredentials [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=119xxxx]/MashupDataAccessCredentialException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupCredentialException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=119xxxx]
Thomas