Work with HTML file

[Anonymous]

Hi Everyone,

Could you please help me with how to load the HTML file created by SAP SM36 into the PBI desktop?

Erhan

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

You're using the From Folder connector to open the file but you'd be better off to use the Web connector.  When it asks you for the URL enter the full path and filename e.g.

You can then choose to load as many tables as you like

Please read this artice which will give you further help about loading tables from HTML files.

https://www.thebiccountant.com/2018/02/10/web-scraping-1-combining-multiple-tables-from-one-page-in-power-bi-and-power-query/

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

Thank you @PhilipTreacy for the solution. I can append all tables into one merge table. If the new data is more than the selected table the solution does not cover it but it is enough for now.

[PhilipTreacy]

Hi @Anonymous 

What method did you use to load the file?

I can load a HTML file from my own PC but that's not the same as loading your HTML file.  Can you supply the HTML file you are working with?

Phil

[Anonymous]

Hi @PhilipTreacy 

I have realized that if the HTML file does not have a header line PBI cannot accept the file. When I tried another HTML file that has a header PBI accepted it as a proper file. (Until now always tried the non-header file)

Now, due to the file has more than one header, PBI sees more than one table and just load the only table1. Do you know how to load all tables at one time?

[Anonymous]

Hello,

I'm having the same problem when trying to load html files created by SAP to PBI desktop. Did you able to find a method to load all the tables at once ?

In my case, I'm trying to connect through a folder which is updated weekly with a new html file. And the no of tables in a file is diffrent from file to file.

[PhilipTreacy]

Hi @Anonymous 

If it's a single HTML file you could load the file from Get data-> More- > Folder then select the file.  If you get the file from a web server/API then use the Web connector.

Phil

[Anonymous]

Hi Philip,

Thank you for your information.

When I try the methodology PBI does not allow to load of HTML file properly. Did you have a chance to load the HTML file properly?