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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
SamaS
Regular Visitor

Power Query : rename multiple columns dynamically

Hello,

I'm using Power Query and Power BI. I use extractions from an automaton and a file allowing me to translate the name of the columns into something understandable.
There are a lot of columns, I would like to find on power query a function allowing me to rename the columns of my table automatically using the 2nd "translation" file

For example: my column name is: "PoofliW" the function would find its translation in the file and automatically replace "PoofliW" with "Power of lights (W)"

Thanks a lot

1 ACCEPTED SOLUTION
ouaelaam
Resolver I
Resolver I

Hi,

I had a similar need and followed the instructions in this blog post :
https://biinsight.com/a-power-query-custom-function-to-rename-all-columns-at-once-in-a-table/

 

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

View solution in original post

1 REPLY 1
ouaelaam
Resolver I
Resolver I

Hi,

I had a similar need and followed the instructions in this blog post :
https://biinsight.com/a-power-query-custom-function-to-rename-all-columns-at-once-in-a-table/

 

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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