Forum Discussion

barakb32's avatar
barakb32
Icon for Advocate I rankAdvocate I
6 years ago

Translate a PowerQuery OData connection to qualified URL

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

Need Help

3 Replies

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    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>"

     

      • mwegener's avatar
        mwegener
        Icon for Most Valuable Professional rankMost Valuable Professional
        6 years ago

        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.