The creator of a connection is automatically its owner. There is no possibility to transfer the ownership to another user. This means, when the login of the original creator is deleted, the connection stops working. This forces us to use a technical / non-person login for the initial creation in order to make sure that working connections are independent from our user management.
Let me transfer the ownership of a connection to another user
Using a shared technical account means additional and unnecessary administration overhead and, when multiple person have access to the password, this can be a security issue. Power BI handles the same situation differently we don't need a technical login there.
... View more