Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Column Titles in Query Editor

In Excel when you create a table, it is possible to use the Column's Headings as the Table's headings.

 

In Power BI Query Editor, is there a way to do the same, instead changing the Column Titles from Column 1 to the correct name?

 

 

  • Hey,

     

    not sure what you mean, if your data source contains the column headers, let's say the first row of your dataset (xlsx, csv ...) contains the correct column names then you can use the 

     

    If the correct column names are not available, you have to rename each column manually.

     

    Regards,

    Tom

2 Replies

  • Hey,

     

    not sure what you mean, if your data source contains the column headers, let's say the first row of your dataset (xlsx, csv ...) contains the correct column names then you can use the 

     

    If the correct column names are not available, you have to rename each column manually.

     

    Regards,

    Tom

    • Anonymous's avatar
      Anonymous
      Not applicable

      That's great, thank you very much.