HTML Table PowerQuery problem moving from PBI Desktop to Dataflow

[wojtek7]

I've created PQ that uses Sharepoint Folder connector to get HTML file and extracts Table from this HTML for further transforamtion

Problem is that PQ is working well in PBI Desktop but after copying to Dataflow in PB Workspace it throws error after getting content of file and while transferring it in HTML.Table step.

Error: Expression.Error: The import Html.Table matches no exports. Did you miss a module reference?

let
    Source = SharePoint.Files("https://aaa.sharepoint.com/teams/aaaaaaaa/", [ApiVersion = 15]),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "20191012.html")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}),
    Content = #"Removed Columns"{0}[Content],
    #"Extracted Table From Html" = Html.Table(Content, {{"Column1", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(1), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(1)"}, {"Column2", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(2), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(2)"}, {"Column3", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(3), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(3)"}, {"Column4", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(4), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(4)"}, {"Column5", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(5), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(5)"}, {"Column6", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(6), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(6)"}, {"Column7", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(7), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(7)"}, {"Column8", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(8), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(8)"}, {"Column9", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(9), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(9)"}, {"Column10", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(10), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(10)"}, {"Column11", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(11), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(11)"}, {"Column12", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(12), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(12)"}, {"Column13", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(13), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(13)"}, {"Column14", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(14), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(14)"}, {"Column15", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(15), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(15)"}, {"Column16", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(16), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(16)"}, {"Column17", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(17), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(17)"}, {"Column18", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(18), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(18)"}, {"Column19", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(19), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(19)"}, {"Column20", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(20), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(20)"}, {"Column21", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(21), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(21)"}, {"Column22", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(22), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(22)"}, {"Column23", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(23), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(23)"}, {"Column24", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(24), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(24)"}, {"Column25", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(25), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(25)"}, {"Column26", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(26), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(26)"}, {"Column27", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(27), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(27)"}, {"Column28", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(28), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(28)"}, {"Column29", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(29), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(29)"}, {"Column30", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(30), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(30)"}, {"Column31", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(31), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(31)"}, {"Column32", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(32), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(32)"}, {"Column33", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(33), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(33)"}, {"Column34", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(34), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(34)"}, {"Column35", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(35), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(35)"}, {"Column36", "HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR > :nth-child(36), HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR > :nth-child(36)"}}, [RowSelector="HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > TR, HTML > BODY:nth-child(2) > TABLE.reportTable.tabularFormat.showDetails:nth-child(8) > * > TR"]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Owner Role", type text}, {"Opportunity Owner", type text}, {"Account ID", type text}, {"Account Name", type text}, {"JLL Account Code", type text}, {"JLL Business Unit", type text}, {"JLL Geography/Sector", type text}, {"Region", type text}, {"Practice ID", type text}, {"Practice", type text}, {"Opportunity ID", type text}, {"Opportunity Name", type text}, {"Description", type text}, {"Stage", type text}, {"Won", type text}, {"Fiscal Period", type text}, {"Amount", type text}, {"Expected Revenue", type text}, {"Amount (converted)", type text}, {"Expected Revenue (converted)", type text}, {"Probability (%)", Percentage.Type}, {"Forecast Category", type text}, {"Last Stage Change Date", type text}, {"Stage Duration", Int64.Type}, {"Age", Int64.Type}, {"Closed", type text}, {"Close Date", type date}, {"Days to Close", Int64.Type}, {"Created Date", type date}, {"Next Step", type text}, {"Lead Source", type text}, {"JLL Referral Details", type text}, {"Type", type text}, {"Is Split", type text}, {"Has Products", type text}, {"Parent Region", type text}})
in
    #"Extracted Table From Html"

[dax]

Hi wojtek7,

You said that this works well in powerbi  desktop , but it didn't work in datafolw, right?I am not sure which factors cause this problem,  I think you could try to re-create this step by step in dataflow instead of paste this directly in dataflow power query to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[wojtek7]

Unfortunately when going through sames steps from Dataflow directly it gives different errors 😞 as per details below.

In Dataflow directly from Workspace using SharePoint Folder connector when I narrow down to exact file and click on Content Binary to get actual HTML for transformation I’m automatically redirected via PQ  wizard to steps which are not happening in PBI Desktop namely:

1. Navigation,
2. Followed by Imported Web and then Imported Web returns Error: "The module named 'Html' has been disabled in this context

shared Query = let
  Source = SharePoint.Files("https://aaaa.sharepoint.com/teams/xxxxxx"),
  #"Filtered rows" = Table.SelectRows(Source, each ([Name] = "20191012.html")),
  Navigation = #"Filtered rows"{[#"Folder Path" = "https://aaaa.sharepoint.com/teams/xxxxxx/Shared Documents/999 Reporting/Opportunites/HTML/", Name = "20191012.html"]}[Content],
  #"Imported Web" = Web.Page(Navigation)
in
  #"Imported Web";