Forum Discussion

Copper Contributor

Oct 17, 2020

Excel Odata authentication

Hi, Trying to connect to an OData feed, but having problems getting authenticated. I am able to do a (not sure if this is the right term) multi step authentication using Postman against the feed, ...

excel

SergeiBaklan

Diamond Contributor

Oct 18, 2020

jjespersen

Jeppe, not sure what exactly you are doing. With Power Pivot procedure is quite simple. On Excel ribbon Data->Get Data->From Other Sources->From OData feed. Here enter OData feed endpoint URL and on next step, when asked, login/password for Basis authentication.

jjespersen
Copper Contributor
Oct 18, 2020
SergeiBaklan I can "see" the endpoint and all the exposed entities, but when trying to preview or load data from them, I am prompted for authentication, and when using Basic authentication, I am not succesful, unfortunately.
- rajeshnichenametla
  Copper Contributor
  Feb 05, 2021
  jjespersen - I am also facing the same issue, could you please share if you have got any luck to connect with Excel Odata authentication.
- SergeiBaklan
  Diamond Contributor
  Oct 18, 2020
  jjespersen
  
  Sorry, then I don't know, not a specialist in OData. We actively use OData feed within organization, both with Excel and Power BI it works with Basic authentication. Plus couple of public resources, they are with Anonymous authentication. Don't know which other options exist.
  
  I'd check with admins if you have correct credentials for Basic authentication. In opposite to your own creds you will never know about Basic auth creds change if admins don't inform you.