Excel External Data Connection Permission

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 authorizati...