Passing Parameter to URL

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.