Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
Solved! Go to Solution.
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'.
#"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
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.
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'.
#"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