Forum Discussion
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...
Update on my question:
I'm thinking if it's possible to create an excel login prompt for username and password, where username and password will then be automatically used to update credentials in power query data source setting.
If this is feasible, then when those non-technical staff open the excel files, the login prompt will show up and the staff can enter the username and password for that API used in power query.
I would like to ask if anybody can kindly explain if my thought is possible? Thx a lot!