Forum Discussion
Excel files 'null' when closed but with data when opened
Hi all, I am importing several hundred Excel files from a folder into Power Query. Unfortunately, for some sheets within every file Power Query shows 'null' only. When I open the sample file and ...
Hi Pat,
Thanks for the tip. Unfortunately, I'm still confronted with the same problem.
When I go to 'get data' --> 'from folder' and on the next window go to 'transform data', this is what I'm seeing:
However, when I open the files and refresh the preview, it recognizes column headers and is filled with data.
If I close the files and hit refresh, I'm back to nulls again.