import folder with multiple HTML files

[dgmush]

Hi All, 

I've searched the forum thoroughly, but I haven't found what I need 😞

I need to import a folder where I have several .htm files ( 15-30 files)

I have understood that there is a connector for folder ( but doesn't read correctly my htm files)

If I use web connector...I can import just one htm file a time

of course all htm files have the same structure,  that I would like to append all togheter.

Any comment/suggestion would be helpful!

I really appreciate any help you can provide.

Diego

[Anonymous · Accepted solution]

Hi @dgmush ,

(1) You can convert html file to csv file, then get data select folder connector, select combine and load.

(2)(1) You can get data to select the folder connector, then add custom columns, expand the custom columns, split the [html] columns based on commas, and use the first row of data as the column headers.

= Table.AddColumn(Source, "Custom", each Table.AddColumn(Source, "html", each Text.FromBinary([Content], BinaryEncoding.Base64)))

You can refer to the following posts that may be helpful to you:

Get data from htm file to Power BI - Microsoft Fabric Community

How to display HMTL file content via Powerbi deskt... - Microsoft Fabric Community

Best Regards,

Neeko Tang

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