Parameterize Odata Feed Link

[MSFTPBI]

Hello,

I would like to parametrize Odata Feed link (server and client id)

My current full link is

https://somethingSAP.mydomain.com:portnum/sap/opu/odata/sap/?sap-ds-debug=true&sap-client=xxx

I would like to parametrize

https://somethingSAP

and

Client

client=xxx

Is it possible? Apprecite your help

[Washivale]

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

[MSFTPBI]

No that will not work,
I'm trying something like

Let

vClientID = ClientID, //(this is a parameter I created)
vServer = Servername //(this is a parameter I created)

Source = https://"&vServer&".mydomain.com:portnum/sap/opu/odata/sap/?sap-ds-debug=true&sap-client="&vClientID...

but it is not working

[MSFTPBI · Accepted solution]

I figured it out thanks

[crln-blue]

Can you share your solution, please? Thank you.

[Marcky]

Hi @MSFTPBI  can you share your solution please?

[Washivale]

ohh ok, I tried this approach with Azure DevOps Odata feeds in past, where we had multiple projects needs to be passed as parameters, we passed list of projects in columns, and then a custom column created to get data for each of the projects listed in the column and then expand it to get records, so thought it would work in scenario as well, sorry to hear that it didnt worked