Forum Discussion
Power Query - non stop connecting and loading
Hi,
I am connecting to an external excel workbook.
On second event,
I already complete transform data then it shows nicely the view i need - saved it as A.xlsx in folder AA. I pull a new file B.xlsx into the same folder AA and refresh the A.xlsx but the table did not capture the new file B.xlsx information in it. Wondering why is it?
Hi sueannwee
Sorry for the late reply. Did you succeed to resolve the first problem?
For the second question, I guess what you want is to get data from multiple files in a folder, so you can go to Get Data > From File > From Folder. After getting all files listed in a table, you need to combine them into a single query. Power Query can do this for you automatically, please refer to
Import data from a folder with multiple files (Power Query) (microsoft.com)
Power Query Get Files from a Folder • My Online Training Hub
Best Regards,
Jing