Forum Discussion
Headers Power Query
Hi, I am combining several files from a folder. The first column (the source column), I need the column header to stay as "source name", but for the other columns, I need to promote the first row...
PowerBI123456
Another thing you can try is to promote your headers in the custom function first, then you won't have this problem. Look for
Transform File (9)
in your queries pane on left hand side, then click into the sample file query steps and add the promoted headers step to the sample file. This should update the custom function and eliminate the need to promote headers in the final query (and also get rid of header rows in the middle of your data that might have been messing things up before).
Another thing you can try is to promote your headers in the custom function first, then you won't have this problem. Look for
Transform File (9)
in your queries pane on left hand side, then click into the sample file query steps and add the promoted headers step to the sample file. This should update the custom function and eliminate the need to promote headers in the final query (and also get rid of header rows in the middle of your data that might have been messing things up before).