Power Query : rename multiple columns dynamically

Samuel Vogel 21 Reputation points
2022-12-26T20:26:25.017+00:00

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

Community Center | Not monitored
0 comments No comments
{count} votes

Accepted answer
  1. Anonymous
    2022-12-26T20:31:32.703+00:00

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
    https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

    The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.