Password gets deleted/ reset after deployment pipeline run

[caseking-jeff]

We have noticed the following behaviour in our Azure Analytics Services deployment pipeline: After the pipeline has succesfully ran, the next processing job will fail with the following error:

OLE DB connection failed to be established
Fehler bei der Anmeldung für den Benutzer "sa".

Which translates to: Login failed for user "sa".

After manually adding the password via the connection settings in SSMS the processing job succeeds with the deployed changes.

Our pipeline has the following settings:

Data source type: Advanced (multiple connections)
Advanced settings:

[
{
"name": "19x.xxx.x.xxx",
"authenticationKind": "UsernamePassword",
"connectionDetails": {
"address": {
"server": "19x.xxx.x.xxx",
"database": "DWH"
}
},
"credential": {
"Username": "sa",
"Password": "xxxxx"
}
}
]

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.