Forum Discussion
import folder with multiple HTML files
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
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.
1 Reply
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.