Power Query Over Multiple File Folder Locations

[snaplink22]

Hello,

I have recently been working with Power Queries and I'm wondering, can you pull data from workbooks that are in multiple different file folders? I've run queries pulling data from multiple documents in one folder, using Get Data, From Folder, but I'm uncertain how to proceed otherwise.

Thank you.

 

[sandy666]

maybe it will help

Import data from a folder with multiple files (Power Query) - Microsoft Support

Use Excel's Get & Transform (Power Query) experience to combine multiple files, which have the same schema, from a single folder into a single table.

support.office.com

or

power query from folder - Google Search

www.google.com

 

[snaplink22]

maybe it will help

Import data from a folder with multiple files (Power Query) - Microsoft Support

Use Excel's Get & Transform (Power Query) experience to combine multiple files, which have the same schema, from a single folder into a single table.

support.office.com

or

power query from folder - Google Search

www.google.com

This states that it only pulls from one file folder though.

 

[RoryA]

I suspect you would have to setup several folder queries and then merge them together. Or set one up as a function then another that loops through say a table of folder paths and then calls the function for each one.

 

[snaplink22]

I suspect you would have to setup several folder queries and then merge them together. Or set one up as a function then another that loops through say a table of folder paths and then calls the function for each one.

Started playing around with it a bit more and I found how to upload another file folders contents. However, the Merge option is not allowing me to click OK to do the merge. My assumption is that since the headers between the two documents to not 100% match, even though the data is the same type for each column, it will not allow me to merge this two folder, correct? Notice the difference between the Date and Work columns below:

 

[snaplink22]

Started playing around with it a bit more and I found how to upload another file folders contents. However, the Merge option is not allowing me to click OK to do the merge. My assumption is that since the headers between the two documents to not 100% match, even though the data is the same type for each column, it will not allow me to merge this two folder, correct? Notice the difference between the Date and Work columns below:

View attachment 12447

It appears that is not the fix. I'm not sure why the OK box is still grayed out and won't allow me to merge these two queries.

 

[snaplink22]

It appears that is not the fix. I'm not sure why the OK box is still grayed out and won't allow me to merge these two queries.

I'm going to stop here and create a new thread as this has change from the original title. Thank you both for you help!