Forum Discussion
How to do rename by script ?
Hi All
My raw data is txt format , when i import to PBI , it ask me to rename all my field name
, since i am doing testing now . i don't want to spend time doing rename the field name , it there short cut on this ? so that after i finish all the import and i can start doing rename at the last step. any suggest. ( problem import raw data file with out header)
Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may add a new step with following m codes
= Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}})Result:
For further information, you may refer to the document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may add a new step with following m codes
= Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}})Result:
For further information, you may refer to the document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , You can do rename at any step. But in some cases they rename can cause the formula to break. I have faced this couple of time.
My advice is before you start creating a new formula column or measure , rename .
So After Import and Data modeling, you should rename and then create additional formula.
