add new column to extracted JSON file

[tooba]

Hi,

I extracted information from .JSON file into Power BI. The data will apear as shown in the screenshot. Then I have to change the foramt by clicking on 'To table'and then select fields that I need to be shown in tables format. 

Data is not cleansed and I can't select all of fields. Hence, I need to add new fields from time to time. I couldn't find any option to add new field to previous extracted fields. Is there any way to do that or I have to start from transforming data from following format into table format whenever I want to add new field?

[deldersveld · Accepted solution]

In Power BI, you cannot edit the JSON document directly. It's safest to parse it into table format and then add a column as you are currently doing.