Hi, My Data Source is From a Folder which consists of csv files. I started with one csv file and added to the data model and created a pivot table. Then when I tried adding my second csv file to the same folder the next day, it didn’t update in power query. Can you tell me what I’m doing wrong? Thank you!
When I add my second CSV file to my folder and refresh, my pivot table isn’t updating automatically with the new information.
Hi Jen,
Using automatic file combiner is not flexible, try the solution from here: https://www.myonlinetraininghub.com/excel-forum/power-query/combine-files-with-different-header-names
A pivot table needs to be refreshed separately than PQ refresh, make sure you refresh the pivot after you refresh the query.
CSV files all have the same headers and as I add a new files each day they will also have the same headers. I was looking to try this method after all I’m hearing about how easy PQ it’s suppose to be by just adding to a folder. And I only need one pivot table. I want to be able to refresh all after adding to a folder to get an updated pivot table. Thanks.
Hi Catalin - I can’t get your file to download that you suggest to try.
Hi Jen,
Please provide sample files that we can test, we are not wizards to see what you are doing (unfortunately).
What do you mean that you cannot download the file? What happens?
