Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
and
Client
Is it possible? Apprecite your help
Solved! Go to Solution.
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
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)
but it is not working
I figured it out thanks
Can you share your solution, please? Thank you.
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |