Action: 'UpdateSqlCreds': Synapse serverless SQL database + Updating credentials of multiple SQL databases

[pphidev]

Hi @maikvandergaag,

For a new use case, I have two questions:

• I would like to use the 'UpdateSqlCreds' action to update the credentials of a (Synapse) serverless SQL database. I've tried this and the pipeline runs successfully in Azure DevOps. However, when I navigate to the semantic model in Power BI and check the "Refresh History", I see the message "The refresh failed for this model," indicating that the credentials haven't been updated. Before running the 'UpdateSqlCreds' action, I let the service principal take ownership of the dataset via another action ('TakeOwnership'). Is the 'UpdateSqlCreds' action compatible with serverless SQL databases?
• I would like to use the 'UpdateSqlCreds' action to update the credentials for multiple (SQL) databases. Is it possible to run the 'UpdateSqlCreds' action for different SQL databases (each having different usernames/passwords)?

Thanks in advance.

Bij voorbaat dank!

Kind regards,

Pim

[maikvandergaag]

Hi Pim,

Never tested in that situation but it should be compatible. So I think something is going wrong. The second usecase should work as well. You only have to configure something that iterates the task over a couple of databases.

[pphidev]

Hi Maik,

Thank you for your response.

Regarding point 2: Suppose I implement some kind of a for loop and I want to update the credentials of two databases. How can I specify in the UpdateSqlCreds action which database it concerns?

Kind regards,

Pim