Power Query not loading all files in a folder

Copper Contributor
Hi, I've got a folder on a network drive with new data added every 24 hours. These CSV files are typically less than 100kb.
I've tried to use Power Query to combine and load but, it's only showing data for the first CSV file and nothing after that.
Within the Power Query transformation window, data from the first file appears as expected, but for data from the second file onwards, a null value appears for all columns.

I would appreciate any opinions/suggestions. Else vba might be my only other option.
1 Reply

Hi @Yram_2165 

 

this sounds a bit as if not all the files have the sames structure. Could you provide more information, maybe upload some example CSV's and/or provide some screenshots from within Power Query.