Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I am trying to figure out how HTML.Table works. Microsoft description of this function is very basic. Let's say I have a simple HTML code "<td> 100.67</td>" from which I want to extract the value (100.67). Trying this code, but it does not give me wanted result, although does not complain about syntax:
= Html.Table("<td> 100.67</td>", { {"myValue", "td"}})
This one does not work either:
= Html.Table("<td>100.67</td>", { {"myValue", "td"}}, [RowSelector="td"])
What am I missing here?
Solved! Go to Solution.
Hi @gvg
It looks like the issue might be with the way the HTML code is formatted. The Html.Table function expects the input HTML code to be in a specific format, with a table structure containing rows and columns. The code you provided is just a single cell in a table, without any surrounding table structure.
Note that in this example, the HTML code has a table structure, with a single row and a single cell containing the value 100.67.
Also, the second parameter of Html.Table is a list of name-selector pairs, not a record. So you should use
let
html = "<table><tr><td>100.67</td></tr></table>",
#"Extracted Table" = Html.Table(html, {{"myValue", "td"}})
in
#"Extracted Table"
Yes, you are right. Thank you!
Hi @gvg
It looks like the issue might be with the way the HTML code is formatted. The Html.Table function expects the input HTML code to be in a specific format, with a table structure containing rows and columns. The code you provided is just a single cell in a table, without any surrounding table structure.
Note that in this example, the HTML code has a table structure, with a single row and a single cell containing the value 100.67.
Also, the second parameter of Html.Table is a list of name-selector pairs, not a record. So you should use
let
html = "<table><tr><td>100.67</td></tr></table>",
#"Extracted Table" = Html.Table(html, {{"myValue", "td"}})
in
#"Extracted Table"