How to info power quary add SEGMENT field ?

[Paulyeo11]

Hi All

I have below raw data , i am able to load the CSV raw data to PBI with out any issue :-

After 2 month later , user request add SEGMENT field :-

I  am able to reload the file , but i need to edit at the power quary editor , by info power quary to adding SEGMENT field . May i know where to click ?

[amitchandak · Accepted solution]

@Paulyeo11 , Right click on Book1, You will options. Choose advance editor.

In that, you will see a field list. You have care fully add the new column to the list.

Alternate. Add this new file to the new pbix. Follow the above steps and get the script with new column. Carefully replace  the old one in other file.

[Paulyeo11]

Hi Amit

Thank you very much for your sharing. This is very helpful.Today i learn a lot of trick.

Paul