How to Auto Fill Column Titles With Row Text

Question

Hello community,&nbsp;&nbsp;I am faced with a couple hundred files which are to be imported to Power BI and I must rename the columns based on the 2rd row in each sheet. What is the best way to automate this?&nbsp;For clarity, each sheet that I am uploading have identical templates - and each of them has the title for the columns in row 2 - and instead of copying and pasting for days - I'd like to use script that will take the text in the second row and [in the same order] rename the columns.&nbsp;Please let me know if more information is needed!&nbsp;Thanks!

imkef · Answer

Hi&nbsp;mwigthe following function renames all columns from a table (Source) to its values from the 2nd row:&nbsp;Table.RenameColumns(Source, List.Zip( { Table.ColumnNames(Source), List.Transform(Record.FieldValues(Source{1}), Text.From) } ))is this what you're looking for?

mwig · Answer

How do I input that into the sheet?&nbsp;

imkef · Answer

Please check out this video with instruction on how to integrate M-code into your solution:

http://community.powerbi.com/t5/Webinars-and-Video-Gallery/Power-BI-Forum-Help-How-to-integrate-M-code-into-your-existing/m-p/179314

mwig · Answer

When I entered the exact formula you posted it gives me an error message and then the entire sheet disappears. I'm sure I have to do some changes to the formula but why would it disable the entire sheet if I type it in wrong?

imkef · Answer

Sorry, but I don't understand what you mean with sheet. Could you please clarify?

Forum Discussion

How to Auto Fill Column Titles With Row Text

5 Replies

Related content

Auto-exits

Remove Matrix Table Column Title

Tooltip - Remove auto title

Auto Chart refresh

Auto Refresh