Oct 17 2020 12:46 PM
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
Oct 18 2020 10:40 AM
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.
Oct 18 2020 12:14 PM
@Sergei Baklan 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.
Oct 18 2020 01:10 PM - edited Oct 18 2020 01:51 PM
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.
Feb 05 2021 02:39 PM
@jjespersen - I am also facing the same issue, could you please share if you have got any luck to connect with Excel Odata authentication.
Mar 18 2021 09:49 AM
@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: