Forum Discussion
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, where I first send a Post from which a token is returned which I use for subsequent Gets.
Can I do this sort of thing in Excel? I know there are some fairly advanced possibilities using the PowerQuery editor (and its Advanced Settings), but I'm unable to find examples and/or tutorials showing how to do this kind of authentication.
I have tried the various authentication options that the standard dialog exposes.
Admittedly, I may not even be asking the right question, but being able to authenticate against the needed feed would make my month. 🙂
Cheers,
Jeppe
5 Replies
jjespersen If you've connected before, Excel won't ask for your credentials again (even if it can't connect using previous credentials). You'll have to clear them manually.
https://kb.blackbaud.com/knowledgebase/Article/118537 shows how:
- Click Data > Click Get Data
- Click Data Source Settings
- Select the connection and click Clear Permissions
- Click Delete when prompted if you want to clear permissions
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.
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.
jjespersen - I am also facing the same issue, could you please share if you have got any luck to connect with Excel Odata authentication.
