I had created a power query that got data from a folder. It's transformed the way I like. I thought that if I added new files or changed data within the existing files and refreshed my query that it would update. The only way I can figure out how to add new data is to recreate the query and append the data. I'm sure there must be an easier way and was looking for some direction. Thanks!
You must be doing something wrong.
1. What is the location of the files you want to pull data from?
2. What is the M code from the query?
3. Are you refreshing the query?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello, no doubt I am lol.
1) The location of my files are in C:\Users\xxx\Documents\Excel\Practice\excel_workbooks.
2) Below is M code
3) To refresh I click on Data>Queries & Connections...this brings up my query and I right click on it and select refresh. Thanks!
Please Login or Register to view this content.
Last edited by AliGW; 05-03-2020 at 12:24 PM. Reason: Code tags added.
I have added code tags for you - they need to be added around code in future, please, as per the forum rules.
This query looks a bit odd to me. Are you able to share a workbook that is in the same format as those you are importing via the query?
I figured it out. I had the new file in the wrong (similar) name folder. After I moved the new file into the right folder path, refresh did what I needed. Thanks for the fast replies!
That would be it - glad it's resolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks