Forum Discussion
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 youHi,
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...
Hi GQ00 Please check what user is the owner of all the Fabric items the Consultant created. Make sure the owner is an active Entra ID user. I would suggest using a service account.
Steps to Take Ownership
- Open your workspace and navigate to the Fabric item you need to take over.
- Click the ellipsis (...) next to the item name and select Settings.
- Go to the About tab and click Take over.
hi thanks for your answer
so after adjusting the connections this was our next port of call. we took ownership of all asset yet data flows continued to failed when run by the pipeline .
- is there anything that would explain that ? is there a way to ensure all assets are own by the newly created service account ?
thanks