Forum Discussion
jjespersen
Oct 17, 2020Copper Contributor
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, ...
Sjlver
Mar 18, 2021Copper Contributor
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