import table with same structure from multiple html documents returns null in all records for random documents

Question

Hi,

What am I trying to achieve is to merge tables(same structure, same no of columns, same name of columns, same order..) from multiple html documents stored localy into one worksheet.
When I import only one document it works fine, but when I try to import all of them, all rows of random files are filled with null. Except the first column where the name of the document is stored.
Can you please help me to understand what am I doing wrong?

Answer 1

Power Query is no longer supported here on Q&A. Please post your question over on https://aka.ms/PQCommunity instead.