

January 13, 2021

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!


November 8, 2013

Hi Jen,
Using automatic file combiner is not flexible, try the solution from here: https://www.myonlinetraininghu.....ader-names
A pivot table needs to be refreshed separately than PQ refresh, make sure you refresh the pivot after you refresh the query.


January 13, 2021

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.
1 Guest(s)
