Forum Discussion

J_Young's avatar
J_Young
New Member
3 years ago
Solved

Combine multipel .htm files with multiple tabels from SharePoint

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 con...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.           

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.           

  • J_Young's avatar
    J_Young
    New Member
    3 years ago

    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

     

  • mshoaibkhalid's avatar
    mshoaibkhalid
    Regular Visitor
    2 years ago

    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.