Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
cdknuth
Frequent Visitor

rename columns based on name (not sure if it's level or hierarchy or attribute)

I'd like to rename my columns either on import or immediately following.

 

Example name that comes in: [DIM A].[YEAR].[YEAR].[MEMBER_CAPTION]

 

Name I want to display: Year

 

Is there a formula for this?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @cdknuth,

 

In query editor, it support rename multiple columns at same time, it can be parameters with list who store lists with 'old name', 'new name'.

 

Table.RenameColumns

#"Renamed Columns" = Table.RenameColumns(#"Previous Steps",
{{OldName,NewName},{OldName1,NewName1},{OldName2,NewName2},{OldName3,NewName3}})

 

In addition, use sql statement in advanced option to replace column names also works for your requirement.

 

Regards,

Xiaoxin Sheng

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

In power Query, right click the column header - > Rename.

 

Thanks
Raj

Thanks, Raj. But I'm looking for a way to rename 5-10 columns at once while importing into Power BI from SSAS.

Anonymous
Not applicable

Hi @cdknuth,

 

In query editor, it support rename multiple columns at same time, it can be parameters with list who store lists with 'old name', 'new name'.

 

Table.RenameColumns

#"Renamed Columns" = Table.RenameColumns(#"Previous Steps",
{{OldName,NewName},{OldName1,NewName1},{OldName2,NewName2},{OldName3,NewName3}})

 

In addition, use sql statement in advanced option to replace column names also works for your requirement.

 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors