Log In
Register
Home
January 13, 2021
Offline
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!
January 13, 2021
Offline
When I add my second CSV file to my folder and refresh, my pivot table isn’t updating automatically with the new information.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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
Offline
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.
January 13, 2021
Offline
Hi Catalin - I can’t get your file to download that you suggest to try.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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?
1 Guest(s)
