Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MSFTPBI
Regular Visitor

Parameterize Odata Feed Link

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

1 ACCEPTED SOLUTION

I figured it out thanks

View solution in original post

6 REPLIES 6
Washivale
Resolver V
Resolver V

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)

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

but it is not working

I figured it out thanks

Can you share your solution, please? Thank you.

 

Hi @MSFTPBI  can you share your solution please?

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.