https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker Marza1991 Tracker Sat, 19 Sep 2026 03:46:17 GMT 2026-09-19T03:46:17Z https://community.fabric.microsoft.com/t5/Power-Query/Help-with-transformation/m-p/3646767#M120062 <P>&nbsp;</P><P>How can I make sure specific transformations such as remove top 3 rows and promote first row to header is applied to all source files when sourcing to a onedrive folder. I’ve successfully removed the top three rows by transforming the “Transform Sample File” but whenever I promote the top row to Column headers I get an error message stating “column 1” of the table wasn’t found.</P><P>This has been so frustrating. I can’t seem to get it to work. Any insight, tips, tricks, help ?</P> Thu, 18 Jan 2024 21:57:50 GMT https://community.fabric.microsoft.com/t5/Power-Query/Help-with-transformation/m-p/3646767#M120062 Marza1991 2024-01-18T21:57:50Z