Hi Experts and Engineers,
I am meeting an issue regarding Excel API connection as Data sources. I am successfully getting data from the web via OData. The permission method is basic authorization, which means a username and password are required.
However, when I shared this file with my non-IT coworkers, the excel required them to enter usernames and passwords. However, this username and password are confidential and cannot be shared.
After testing other APIs, I realized that excel will store the permissions locally. I had an idea that we can get these permission local files so that we can put the files on my coworkers' PC. If so, they would not have to enter usernames and passwords again and the info also won't be exposed.
Does anyone have an idea where the permission files are or a better solution for sharing API data without entering usernames and passwords? Appreciate you!
Best,
Zhen
