Format Multiple Column Names At Once in Power Query Editor

[Anonymous]

Hi,

Small issue I always have, I don't think there is a workaround, but please correct me if I'm wrong.

Often when I pull in data I get a bunch of columns names with formatting that I don't like (e.g. capitalization). Is there a way to change them all at once, rather than rename them individually?

Note: I'm talking about the names of the columns, not any of the data itself. Like I said, it's a small issue, but I'm a stickler for formatting.

Thanks

[v-yuta-msft]

@Anonymous ,

Currently, I'm afraid power bi doesn't have this feature. In addtion, it's also not recommend to modify the columns headers because some errors may occur when power bi can't match the column headers in power query and in data source.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.