Power Query : rename multiple columns dynamically

[SamaS]

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

[ouaelaam · Accepted solution]

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.