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.