Powerquery allows you to pull files from folders. But you'll run into some limitations using the out of box functionality in terms of performance and the number of queries. In this video i show how to pull data from multiple folders in a single query using custom functions.
#powerquery #m #mquery #excel #data #dataanalytics

Links
Excel.Workbook Function
https://learn.microsoft.com/en-us/pow...

My Linked in Profile
  / james-botes-basensei