Gateway refresh getting failed with below error

[Anonymous]

{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the Snowflake source are invalid. }},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"Snowflake"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind","detail":{"type":1,"value":"Snowflake"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath","detail":{"type":1,"value":}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":""}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Snowflake\",\"path\":\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}}

[arvindsingh802]

Please check with your Power BI Admin to confirm if SSO authentication is enable in Power BI Admin Portal
https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake 

If it is already enabled then It could be because of Snowflake is not allowing the ype of authentication then you have to reach out to Snowflake Admin and request a new username  & password with basic authentication and that will work for you.

[Anonymous]

@Jayee 

Credentials are working fine in powerbi desktop , i  have refreshed just now ,all is working fine.Getting this error.

[Jayee]

After publish to service did you signed in with your credintials in dataset settings - "data source creditals"?

[Anonymous]

@Jayee  Yes

[Jayee]

If the authentication is SSO and no data gateway is required in your scenario then I think you need to check internally.

[Anonymous]

@Jayee  Could you help me further?

[Jayee]

Hi @Anonymous ,

Please check your credintials error in 4th line :"The credentials provided for the Snowflake source are invalid"