My set up: I retrieved a single csv file from a folder and transformed the raw data. The goal is to be able to combine additional csv files in the same folder and click refresh so that the new data will follow my applied steps.
For some reason my additional csv files aren't able to load due to my final applied step:
#"Filtered Rows2" = Table.SelectRows(#"Added Custom", each ([Subsidiary] <> "Subsidiary "))
The refresh works up until that point. What can I do to make it so that whenever I add a new csv file into my folder, it will combine but also filter out the rows with the word "Subsidiary"? Any help is much appreciated!