This is one those problems that occurs when you have worked quite a bit with Power Query user interface but there seems to be no workaround to expand all columns dynamically.   Watch a Video ? The Problem – Expand All Columns While expanding (combining) data from multiple sources the column names get hardcoded. For … Continue reading Expand All Columns Dynamically in Power Query