Log In
Register
Home
January 13, 2021
Offline
When my source file is a Folder with csv files being added to it every day that all contain the same structure, should get and transform begin with 2 or more of the files so that power query will automatically update as more csv files are added to the folder?
July 16, 2010
Offline
Hi Jen,
As long as you use the Get Files > From Folder path it doesn't matter if there's only one file in the folder. Just make sure that file is representative of the other files that will be added. i.e. column names and number of columns.
Mynda
January 13, 2021
Offline
Hi Mynda,
Yes they are all the same structure just with different data I’m the columns.
When I added my second csv file it is not updating and I refreshed everything. I only see the one query containing rows from the first csv file. Is it ok that my source data is located in a sub-folder? Perhaps this is the problem?
Thank you
1 Guest(s)
