Use Power Query to call API that requires Auth & share excel file to non-technical colleagues

I am using From Web to call an Auth-required API which returns data in JSON.   Since this API requires Auth (username and password)  to access, I set it in excel's Data Source Settings -> Credentia...