Html.Table is a Power Query M function that returns a table containing the results of running the specified CSS selectors against the provided HTML.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Html.Table(
html as any,
columnNameSelectorPairs as list,
optional options as nullable record,
) as tableDescription
Returns a table containing the results of running the specified CSS selectors against the provided html. An optional record parameter, options, may be provided to specify additional properties. The record can contain the following fields:
RowSelector
Examples
Returns a table from a sample html text value.
// Output: #table( {"Name", "Title"}, {{"Jo", "Manager"}} )
Html.Table( "JoManager", {{"Name", ".name"}, {"Title", "span"}}, [RowSelector=".name"] )Extracts all the hrefs from a sample html text value.
// Output: #table( {"Link"}, {{"/test.html"}} )
Html.Table( "Test", {{"Link", "a", each [Attributes][href]}} )