Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |