import folder with multiple HTML files

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.