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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.