Combine multipel .htm files with multiple tabels from SharePoint

Hi J_Young ,

Here's an example of how to do this in Power Query Editor:

1.Connect to the SharePoint folder and navigate to the Power Query Editor.

2.In the Power Query Editor, select the "Add Column" tab and click on "Custom Column".

3.In the "Custom Column" formula, use the Web.Page function to transform the content of each file:

= Web.Page([Content])

4.Click "OK" to create the custom column.

5.Expand the custom column by clicking on the expand icon (two arrows) in the column header.

6.Select the tables you want to combine and click "OK".

7.Use the "Append Queries" or "Merge Queries" options in the "Home" tab to combine the tables as needed.

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

Best Regards,

Stephen Tao

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