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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors