Forum Discussion
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
- TomMartensSuper User
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
- AnonymousNot applicable
That's great, thank you very much.