Passing Parameter to URL

[umutkaya79]

Hi everyone, 

I would appreciate any suggestions and thank you in advance.  

I created a parameter (selectedMarket) has 2 values in the list (nysio and miso are the market names) :

And I have a data coming from a WEB through API.   I am trying to pass the selectedMarket parameter to a market value in the URL, so when I select the market from the slicer I can display the related data (market) based on the selection.  

I tried to pass the parameter in the Advance Editor. (tried as "selectedMarket" also with single qutoes and also with 

& selectedMarket &) but I am getting errors everytime. 

Trying to pass the parameter to the market name.  (Its in the middle of the URL, says nyiso)

Parameter pops up when I am typing it with the double quotes.: 

But it says token comma expected:

Then I replace it with single quotes or put double double quotes around the parameter and says : No syntax errors : 

After I hit done, I get an error : 

Couldn't figure it out.  

Thank you 

[v-jianboli-msft · Accepted solution]

Hi @umutkaya79 ,

Based on your description, I have created a simple sample:

let
    Source = Web.BrowserContents("https://learn.microsoft.com/en-us/dax/financial-functions-dax"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE.table.table-sm > * > TR > :nth-child(1)"}, {"Column2", "TABLE.table.table-sm > * > TR > :nth-child(2)"}}, [RowSelector="TABLE.table.table-sm > * > TR"]),
    #"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Function", type text}, {"Description", type text}})
in
    #"Changed Type1"

Then created a parameter:

Manage the query:

Final output:

For more details, please refer to:

Web.Contents - PowerQuery M | Microsoft Learn

Is it possible to dynamically update the source URL with Power Query ? (microsoft.com)

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.