Hi @David Jenkins ,
I suggest you refer to these links and check if you can get any help from it:
https://stackoverflow.com/questions/33225590/authenticating-with-excel-power-query-against-net-odata-web-api
https://learn.microsoft.com/en-us/powerquery-m/odata-feed
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.