User Profile
Waterfront
New Member
Joined 9 months ago
User Widgets
Contributions
Column1 Not Found" Error in Power Query Folder Combine After Promoting Headers
Hi Power BI Community, I’m combining multiple Excel files from a folder in Power Query to create a dataset for Power BI dashboards. Each file has the same structure (~50–60 columns, headers in the 4th row, named tabs like "File_1", "File_2"). My goal is to clean the data (remove columns, change data types), extract specific columns into queries, append them, and load to Power BI.Setup: Source: Folder with multiple Excel files. Helper Queries: Transform Sample File and Parameter1. Combined File: Combines files, includes "Source.Name" (tab names) and data columns. Transform Sample File Steps: Remove top 3 rows. Promote 4th row as headers (e.g., "ID", "Value"). Combined File Steps: Source > Invoke Custom Function (uses Content column, Parameter1) > Removed Other Columns1 (error occurs here). Issue: "Column1 Not Found" Error After promoting headers in the Transform Sample File, the Combined File shows an error in the "Removed Other Columns1" step: "Expression.Error: The column 'Column1' of the table wasn't found." What I’ve Tried: Deleted the "Removed Other Columns1" step, but the error persists in other steps. Reconfigured the Invoke Custom Function step to use the Content column and Transform Sample File. Verified all files have identical structure. Question: How do I fix the "Column1 not found" error? Should I address it in the Combined File or Transform Sample File? Additional Info: I need "Source.Name" to track file identifiers (e.g., extract "1" from "File_1"). Using Power BI Desktop, recent version.Thanks for any help resolving the error and guiding my workflow!Best regards, WaterFront1.1KViews0likes3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.