Translate a PowerQuery OData connection to qualified URL

[barakb32]

Hello,

I can connect with Power BI to a system named CornerStone with OData string they generate and instruct to copy to power BI.

It looks like this:

OData.Feed("https://<Server>/odata/api/views/vw_rpt_ou", null, [Headers=[#"Authorization" = "Basic <User>",#"x-csod-session-token" = "<Token>"]])

I would like to connect SSIS instead of Power BI, using the OData connector, but the above is not a qualified URL. Can anyone help me transform the above to a qualified URL?

Thanks,

Barak

[mwegener]

Hi @barakb32 ,

this is your ODATA URL = https://<Server>/odata/api/views/vw_rpt_ou

and this are the credentials

"Authorization" = "Basic <User>",

#"x-csod-session-token" = "<Token>"

[barakb32]

10x, @mwegener

Can I constract a single URI line from these?

Barak

[mwegener]

Hi @barakb32,

No, the credentials are part of the header. I'm not sure if you can transfer a token in the header with ssis.