Improve management of Credentials (usernames/passwords etc.) in Power Query and Data Sources
Managing credentials in PowerQuery and other data imports is a pain and is all over the place especially if you pull in data from external systems with password expiry and when you share workbooks with embedded connects.
Is it possible to manage all credentials in Excel centrally with sane ways to change/update passwords and see what credentials are shared/not share when sending/sharing a Workbook? I.e. a big button called "Manage Credentials" which shows a list of all usernames and passwords/credentials, an option to change it, an option to not embed the password, to always ask for a password, to switch to Windows Integrated authentication and integrate it with the "Document Inspector" to give an option to clear all usernames and passwords.