To buy or try WBMerge: http://bit.ly/2WH82Qt
Save 20% on WBMerge through June 30 2019 using discount code MREXCEL
In this video, I try the WBMerge utility on a collection of Excel workbooks that might be problematic in Power Query.
WBMerge is a $39 utility from Workbook Tools. The utility can merge data from multiple Excel workbook or multiple Google Sheets files.