Forum Discussion

6 Replies

  • Washivale's avatar
    Washivale
    Resolver V
    3 years ago

    Hi MSFTPBI : store your parameter as column on  new query and refer it in new custom column with ODATA feed URL

    something like below should work

    let
    Source = Parameter6,
    #"Converted to Table" = #table(1, {{Source}}),
    #"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each OData.Feed("https://"&[Column1]&".mydomain.com:portnum/sap/opu/odata/sap/?sap-ds-debug=true&sap-client=xxx"))
    in
    #"Added Custom"

    you can use Odata.Feed(......) from your current version of query and switch values with parameters

     

    Regards,

    Washivale