Thanks for posting your question in the Microsoft Q&A forum.
I have two suggestions to address your issue:
Service Principal with Key Vault: Securely store SPN keys in Azure Key Vault and authenticate using a Service Principal. This ensures sensitive credentials are protected and accessed securely when needed.
Centralized Management: Utilize Key Vault for centralized management of secrets across multiple data sources. This streamlines credential management without requiring involvement from each source team individually, enhancing security and operational efficiency.
Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful