Forum Discussion
Data not loading correctly from folder with excel files
Advocate IIIAre you saying that each files contents is the word "Supplier" which is in one of the merged cells A10:B10 (the entry will be in one of them even if the cells are merged)? That column C empty and that cell D10 has the name of the supplier in it, and that's it? Is there nothing else in the files? I think you need to provide a but more detail to get some help.
The file has more information, and I'm making several extractions from it.
Each file is a purchase order and I'm making a PBI of all of them togheter.
There is a list of items in cells a16:g32 (column A = item number, B =description, C = quantity, etc)
There is a project number in other set of cells, etc.
The issue is the files that don't show the supplier and I can't find a reason. I don't know why the info doesn't show in Power Query but can be seen in the original excel file.
I copied the cells A10:b10 from a working file and there was no change.