I'm trying to pull some data from ADO online using the oData connector in SSIS (Visual Studio 2019 and SSDT - all on latest versions). Using this URL (redacted our site info), and it works without issue in the browser:
https://analytics.dev.azure.com/*****/***/_odata/v4.0-preview/WorkItems
But when I add an OData Source into an SSIS Data Flow no matter which authentication method I use I get 401 Unauthorized. Can someone give any insight on what I may be missing? Thanks.
