How to merge multiple Excel files with Power BI

This post addresses a common scenario where a business unit may have multiple copies of the same Excel file that they need to aggregate into a consolidated data set for reporting.