Forum Discussion
Rename field without breaking dependent measures
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?
5 Replies
Jimmy801Community Champion
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
JimmyI 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"
- amitchandak
Super User
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?
I am using a data set, with multiple reports
Changing it in the report will duplicate the work (as I have many columns)
- Icey
Community Support
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.
