Forum Discussion

umutkaya79's avatar
umutkaya79
Icon for Helper I rankHelper I
3 years ago
Solved

Passing Parameter to URL

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 

 

Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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. 

1 Reply

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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.