Rename field without breaking dependent measures

[1katznir]

The Use Case:

I am pulling a table from DWH with names as "ABC_DEF"

I would like to go over all the names and rename it to "Abc Def" (in some cases I would like to manually go over the names in cases of "ID" for example)

The Problem:

When I try to rename it in PowerQuery, dependent measures break,

What is the solution for this?

[Icey]

Hi @1katznir ,

To my knowledge, what @amitchandak mentioned is the only way to "rename fields without breaking dependent measures". Because if you fixed at the dataset (Power Query Dataload), the model and the report will not recognize it.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@1katznir , I renamed columns and measures in Table(Data pane/visualization pane) and field (outside power Query) and it hardly broke any measure. Have you tried there?

[1katznir]

I am using a data set, with multiple reports
Changing it in the report will duplicate the work (as I have many columns)

[Jimmy801]

Hello @1katznir 

create a new column were you making the changes. So you can use the new column for new purposes and keep the old for your measures.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[1katznir]

I would like to rename all fields extracted from DWH into the dataset,
I don't think it's convinient to double the fields such as: 
field: "ORIGINAL_FIELD"

new field: "Original Field" refrencing "ORIGINAL_FIELD"