Error at time refresh scheduler

[vijay22kar]

Please help to resolve below error

Underlying error code: -2147467259
Underlying error message: The credentials provided for the MySql source are invalid. (Source at 10.0.0.00;databasename.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: MySql
Microsoft.Data.Mashup.CredentialError.DataSourcePath: 10.0.0.00;databasename

Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"MySql","path":"10.0.0.00;databasename"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized
Cluster URI: WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: e2ca9c41-0869-4de2-b7d4-35dd6cea1a2a
Request ID: d386236e-021a-ca14-3422-d537b291883a
Time: 2021-07-07 11:20:51Z

[ibarrau · Accepted solution]

Hi. The error has the message you need. Please read it.

Usually the second line is the one with the text that will help you. In this case: "The credentials provided for the MySql source are invalid". You are providing wrong credentials to the MySQL source in the Service or somebody has changed those old credentials and now it's not working.

I hope that helps,

[v-angzheng-msft · Accepted solution]

Hi, @vijay22kar 

According to the error message above, the reason is that the access credentials are invalid.
The workaround is to re-edit a valid access credential.
You can view or edit it under Data Source Credentials or you can add a new data source under Manage Gateways.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vijay22kar]

checked credentials but the same error occurred

[v-angzheng-msft]

Hi, @vijay22kar 

However, this connection failure is still a credential issue.

Best Regards,
Community Support Team _ Zeon Zheng

[ibarrau · Accepted solution]

Hi. The error has the message you need. Please read it.

Usually the second line is the one with the text that will help you. In this case: "The credentials provided for the MySql source are invalid". You are providing wrong credentials to the MySQL source in the Service or somebody has changed those old credentials and now it's not working.

I hope that helps,