Forum Discussion

SteveMtz's avatar
SteveMtz
New Member
3 years ago

Data not loading correctly from folder with excel files

I'm uploading data from a folder with multiple excel files. 

The files are all the same, cells A10:B10 are merged and have "Supplier" written and the name of the supplier is on cell D10

 

I import the files and then filter by the first column looking for "Supplier" and there are 5 files out of 50 that don't show after the filter.

 

I verified the original files and the word "Supplier" is in the same cells as the rest of the files but when I look for it in Power Query, the 5 files show null for the same cells.  (the name of the supplier does appear in power query for all files)

 

Please Help

Need Help

2 Replies

  • androo's avatar
    androo
    Advocate III
    3 years ago

    Are 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.

    • SteveMtz's avatar
      SteveMtz
      New Member
      3 years ago

      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.