credential management best practices?

Hi GQ00 ,

Some connections that use the previous item owner's credentials might stop working if the new item owner doesn't have access to the connection. In such cases, you might see a warning message.

In this scenario, the new item owner can fix connections by going into the item and replacing the connection with a new or existing connection.

For Dataflows please consider editing the data source credentials by following this article:

Data source management - Microsoft Fabric | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.
Thank you

Hi,

Tried using a dedicated service account,it didnt work for all connections.

Also if the consultants account has been deactivated for months, how come the pipeline was still working? Somehow the token expired only 60 days after last log in, and to my knowledge, I have no way to knowing this... what a way to be blindsighted on a monday morning.

Anyway, we ended up creating a dedicated user account, to own the connections and also allow it to own the assets (DF, PL, NB) while still editing them if needed.

It all seems to be working now, but yet another additional license just to keep things running...