Forum Discussion
Work with HTML file
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.
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.
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?
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.