1. After connecting to the spreadsheet, right-click the file name and select Transform Data (don't select each individual sheet):
2. Modify the M code by changing the second argument to "true" (prevents repetition of column headers):
Excel.Workbook(File.Contents("C:\Users\MultiSheetImport.xlsx"), true, true)
3. In the Data column, click the Expand icon (double arrow):
4. Uncheck "Use original column name as prefix":
Result:
1. After connecting to the spreadsheet, right-click the file name and select Transform Data (don't select each individual sheet):
2. Modify the M code by changing the second argument to "true" (prevents repetition of column headers):
Excel.Workbook(File.Contents("C:\Users\MultiSheetImport.xlsx"), true, true)
3. In the Data column, click the Expand icon (double arrow):
4. Uncheck "Use original column name as prefix":
Result:
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
