Excel External Data Connection Permission

Excel External Data Connection Permission
0

Upvotes

Upvote

 May 12 2022
1 Comments (1 New)
New

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

Comments
Frequent Visitor

Hey, 

 

Anyone can help?