Power Query - Data from many folders with Single Query

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/powerquery-m/excel-workbook My Linked in Profile https://www.linkedin.com/in/james-botes-basensei/