Hey @Ralf Mark ,
You can use the TMSL script to update the connection details dynamically .
In Azure Devops , we use Azure Analysis service TMSL task to execute it and below is the parameterization of the script :
{
"createOrReplace": {
"object": {
"database": "$(Model Name)",
"dataSource": "AEDW"
},
"dataSource": {
"name": "AEDW",
"connectionString": "Persist Security Info=false;User ID=$(AEDW Username);Password=$(AEDW Password);Encrypt=true;TrustServerCertificate=false;Data Source=$(AEDW Server Name);Initial Catalog=AEDW",
"impersonationMode": "impersonateAccount",
"account": "dev",
"provider": "System.Data.SqlClient",
"annotations": [
{
"name": "ConnectionEditUISource",
"value": "AzureSqlDW"
}
]
}
}
}
Note: You can get the script by right clicking on your connection details and view script .
The above is just a sample one