Forum Discussion
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
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.
1 Reply
- ouaelaamResolver 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.