Hi there,
I'm a Power Query newbie. Working on Power Query course, section 2.05. I was able to successfully get multiple files from a folder using the practice Excel files provided. I wanted be sure that I could close the query/file that I had created, open it again, and then add a new file using Refresh. So this is what I did:
1. I saved my original query and file and then closed it.
2. I copied one of the practice excel files, gave it a new name, and updated the date column to "1/1/2016", saved it to the same folder and then closed it.
3. Opened the original query and pressed refresh. The new data did not come in.
I am sure that there is a really simple thing I am overlooking--so simple that Googling it has been useless in helping me troubleshoot! Can you help me? We get new data regularly and this would be such a wonderful easy way to pull it in.
I have attached my original query/file called "Sample data" and I have attached the copied practice file that I tried to add.
Warmly,
Priscilla
Hi Priscilla,
Thanks for sharing your file. There's nothing in the query that's obviously causing the problem. Please check the file is actually in the folder:
C:Home folderPower QueryPractice Filespq_2.05_excel_workbooks
Also open the new file you created and check the data is in a table called Table1.
If that doesn't work, please share your new file so I can take a look.
Mynda
Sorry--I figured it out. I had to add a path to the trusted locations. That was a lesson well learned!
Thank you!
Hmmm, that's not usually a requirement when you get files from a folder.
