Renaming of fields to business name

[RacAgr]

Hello all

i have 200 fields in DB which are to be used in power BI,

what is the best method to rename them to business name 

for exampl -

prod_nm as Product Name

cust_addr as Customer Address

thanks

[Salvador]

Hi, 

I use the query editor 😄

[RacAgr]

if there are few columns (ex - 5-10), then the approach indicated by you would be better..

but i guess, for 200 columns to rename in power BI, is there any method or better approach.

[v-caliao-msft]

@RacAgr,

Currently, there is no such a function to rename all the columns at a time in Power BI desktop. I am afraid that you need rename the columns one by one.

Thank you for your understanding.

Regards,

Charlie Liao

[Salvador]

Hi,

I'd say that, on that same editor, use the advanced editor and put it in M... or I would create an excel table with the names as they are in your dataset, then the names you want, put that table into the model, and use the names from that table 😛

[Anonymous]

Could you elaborate more on this process. I have a to change all the column names in my model to a different language. I have the translated values, but don't want to have to change each one individually. Thanks!

[Salvador]

Hi,

This is a link to the files in my onedrive 😄 https://1drv.ms/f/s!AqNjbKd67a9ghchOdCfy9eAnt6FLoA

Long story short, there's one exel (1) that has product name and price, other exel (2), has the product name, and the name we want to show, then I load them to power bi, and establish a relationship using the product name, so now I can show the product price with the new product name 😄

I've loaded both the excel files and the pbiex into onedrive ^^