Authenticating OData.Feed using Web API difficulty

I'm in Excel and Power BI. I made my own backend api service that provides data in OData format... That all works great.   I can use the basic authentication just fine. But I want to also be able t...