How to do rename by script ?

[Anonymous]

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)

[v-alq-msft · Accepted solution]

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.

[amitchandak]

@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.