Merge Multiple Files With Properties
This post illustrates a cool technique that I learned at the MVP summit last week, allowing us to use Power Query to merge multiple files with properties from the file in the output. A specific example of where this is useful is