Forum Discussion

rachelb123's avatar
rachelb123
Helper I
8 months ago
Solved

data source credentials issues and unable to remove files data flow

The owner of this dashboard left the company and I have to manage it in the interim. I took over the credentials as their account became inactive and I keep getting errors on two of the web connectio...
Dataflow
Need Help
  • v-sshirivolu's avatar
    v-sshirivolu
    8 months ago

    Hi rachelb123 ,
    Thanks for reaching out Microsoft Fabric Community Foum.

    The best and most reliable fix is to first remove anything in your dataflow or report that is still using the old Web connection, then refresh the workspace, and finally delete and add the source again with new credentials. The reason this works is because the system won’t let you delete a data source if it is still being used anywhere. By opening the dataflow and temporarily removing or disabling the queries that depend on that Web link, you break that link so Fabric no longer considers it active. Once you save and refresh, the old connection becomes free, and you should now see the option to delete it in Manage Connections & Gateways. After that, you can recreate the connection cleanly using your own login. 
    Thank you.

v-sshirivolu's avatar
v-sshirivolu
Community Support
8 months ago

Hi rachelb123 ,
Thanks for reaching out Microsoft Fabric Community Foum.

The best and most reliable fix is to first remove anything in your dataflow or report that is still using the old Web connection, then refresh the workspace, and finally delete and add the source again with new credentials. The reason this works is because the system won’t let you delete a data source if it is still being used anywhere. By opening the dataflow and temporarily removing or disabling the queries that depend on that Web link, you break that link so Fabric no longer considers it active. Once you save and refresh, the old connection becomes free, and you should now see the option to delete it in Manage Connections & Gateways. After that, you can recreate the connection cleanly using your own login. 
Thank you.