Combine multipel .htm files with multiple tabels from SharePoint

[J_Young]

Hello everyone, 
I habe a problem by reading multiple .htm files from SAP into PowerBI. The files are stored in a SharePoint folder and each one has a varying number of tabels. 
Normally a file consits of >50 tabels. Everything works fine by using a single file via Web.Page. If I want to apply this step for serval tabels, I always have to choose one.
Do you know a way to solve the problem?
Many thanks in advance. 

[Azahaar]

Hi All,

I have the same problem. I need to use exported HTM SAP files as data sources. The HTM files are in a SharePoint folder. The Web.Page function is a good solution in the beginning, and everything is perfect on the Power BI desktop until publishing. Due to the Web.Page function, I cannot set up a scheduled refresh on the workspace. Anyone could find a solution for this?

Thank you for your help in advance!

Data source error: [ValidateMarkupTags][ccon]Expression.Error: The module named '[ccon]Html[/ccon]' has been disabled in this context.. [/ccon]. The exception was raised by the IDbCommand interface. Table: NL01_DO_SL_FOR PRICING.
Cluster URI: WABI-NORTH-EUROPE-G-PRIMARY-redirect.analysis.windows.net
Activity ID: 1d5e3c92-fdde-4b8f-b504-57af8f3a278b
Request ID: eabdd409-9395-479e-866f-e45b210ddbce
Time: 2024-03-01 04:23:33Z

[Anonymous · Accepted solution]

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.           

[mshoaibkhalid]

Hi,

The provided solution works perfectly, but when refreshed with a bit of high data (before publishing), getting below error. Scripting is active. 

Erorr 
OLE DB or ODBC error: [DataSource.Error] The Web.Page function
requires Active Scripting to be enabled in Internet Explorer
options. See https://go.microsoft.com/fwlink/?Linkld=506565 for
details on how to enable Active Scripting.

If anyone encounters a similar issue, please share.

[J_Young]

Hi @Anonymous, 

unfortunately I get an error message after adding the Web.Page column. "The credentials provided are invalid." I've tried to reconfigure the credentials via data source settings - unsuccessfully. Do you know how to fix this? 

Best regards