Forum Discussion
Over 45+ folder structures to pull .txt/.csv file from via Power Query
sounds like a standard process. What have you tried and where are you stuck?
Thank you for your reply! The issue is how to just import .txt files > than a certain date. The dates are found in the name itself and the column pulled in Power Query. How can just have a refresh on file names > than , say , November 23rd, 2023? Thank you!
create a new date column from the file name, then apply your filter on that new column.
I must test that as I found if I do any filtering on the date column then when a new file enters the folders it does not update my slicer to show the latest file as it is obeying the filter placed.
So I am getting the standard error message about 'hand authored ' queries therefore it will not upload to the cloud
you should use \\emirprd\edwdata as your only data source.
can you show some more of the Power Query script?
Sure--I must connect to 48 folders to pull the latest .csv file
ex: Step 1 = add Folder
Step 2 = set up custom filter so it pulls after October (3 months prior from today)
