Encountered user gateway exception. The credentials provided for the PowerBI source are invalid

[marcritchie]

I'm having a problem with a dataflow that seems to reoccur every morning after functioning correctly the previous afternoon. In the refresh history log it gives the following error:

Error: Encountered user gateway exception: '<ccon>The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.CredentialError.DataSourceKind]=PowerBI [Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind]=Web [Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath]=https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails [Microsoft.Data.Mashup.CredentialError.DataSourcePath]=PowerBI [Microsoft.Data.Mashup.CredentialError.Reason]=AccessForbidden [Microsoft.Data.Mashup.MashupSecurityException.DataSources]=[{"kind":"PowerBI" "path":"PowerBI"}] [Microsoft.Data.Mashup.MashupSecurityException.Reason]=AccessForbidden [InnerType]=MashupCredentialException The credentials provided for the PowerBI source are invalid. (Source at PowerBI.) [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_InvalidConnectionCredentials [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=830927]/MashupDataAccessCredentialException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupCredentialException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=830927]'. RootActivityId = b7685438-32e7-4086-a129-0e9d5ec4ac91.Param1 = <ccon>The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.CredentialError.DataSourceKind]=PowerBI [Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind]=Web [Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath]=https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails [Microsoft.Data.Mashup.CredentialError.DataSourcePath]=PowerBI [Microsoft.Data.Mashup.CredentialError.Reason]=AccessForbidden [Microsoft.Data.Mashup.MashupSecurityException.DataSources]=[{"kind":"PowerBI" "path":"PowerBI"}] [Microsoft.Data.Mashup.MashupSecurityException.Reason]=AccessForbidden [InnerType]=MashupCredentialException The credentials provided for the PowerBI source are invalid. (Source at PowerBI.) [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_InvalidConnectionCredentials [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=830927]/MashupDataAccessCredentialException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupCredentialException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=830927] Request ID: ad7bb2b3-f898-43f7-9788-7fab4416aa79.

I've checked all connections in 'Manage connections and gateways' and reauthenticated everything. I've also checked the dataset for this dataflow to make sure it is all set up correctly. It's becoming really frustrating as it seems to break overnight every day and I have to spend time every day trying different things to get it to work.

[v-xiaoyan-msft]

Hi @marcritchie ,

This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform. Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

Best regards.
Community Support Team_ Caitlyn

[tbastian]

Hello , 

Any Updates on this error ? @marcritchie @v-xiaoyan-msft 

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 

[maharjanb]

Is there any update in this issue? the frequency of similar issue is increasing too much in our end too.