How Can I connect to this OData Feed in SSIS

[nicolewells]

I have access to a corporate OData feed, but I can only to connect to it from specific applications. (PowerBI, Excel and LinqPad)

The connection details I have, are a URL and Basic Auth Username and Password. However, I know the feed is stored in Azure (not sure which part...) and I think I need some other kind of Authentication to connect.

I am using the latest version of SQL Data Tools and Visual Studio 2015 U2. I have tried using the built in OData connection manager with all of the possible Auth Types and the user/pass i was given with no luck. (Windows Auth, Basic Auth, Microsoft Dynamics AX Online, Microsoft Dynamics CRM Online, Microsoft Online Services)

What confuses me, is why it works fine in LinqPad, Excel and PowerBI but i can't get SSIS to connect. Which i need for data automation!

I have attempted to get the connection string from LinqPad using this but I get an error about UserQuery not having a property Connection. Which may be something to do with Entity Framework?

Does anyone know any tips or tricks to get this working?

[ahdatabase2]

I have a similar problem.  I can not seem to convert it to use in SSIS.  Any suggestion, I would be greatful ssis odata source

m query: fn_GetTimesheetsByDate
let
Source = OData.Feed("https://xyz-odata.company.com"),
#"GetTimesheetsByDate"
= Source{ [Name="GetTimesheetsByDate"
,Signature="function (StartDate as datetimezone, EndDate as datetimezone) as table"]}[Data]
in
#"GetTimesheetsByDate"

[Greg_Deckler]

Unfortunately, this is an Power BI forum and I'm not sure how many SSIS experts hang out here. You may have better luck on a different forum that specializes in SQL. That being said, have you gone into the Query Editor and opened up Advanced Editor in Power BI? The first line should be a Source line and perhaps it will give you the connection string you need or some hint for it.