Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
wojtek7
New Member

HTML Table PowerQuery problem moving from PBI Desktop to Dataflow

‎10-14-2019 01:49 PM
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"
 
 
 
 
 
Labels:
Message 1 of 3
475 Views
0
2 REPLIES 2
dax
Community Support
Community Support

‎10-14-2019 11:38 PM

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.

Message 2 of 3
435 Views
0
wojtek7
New Member
In response to dax

‎10-15-2019 09:27 AM

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

Clipboard01.png

 

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";
Message 3 of 3
422 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All