Forum Discussion

cesarvinas's avatar
cesarvinas
Advocate I
7 years ago
Solved

Transform content to JSON is not working

I have the following JSON content within one colum of my data set in Power BI Desktop:      {valueMap={3={adTitle=User's Attributes, userAttr={Company=xxxxxxxxxx}, fields=[XX_XXXXXX_FIELD_AD {ID =...
  • Anonymous's avatar
    Anonymous
    7 years ago

    If all your JSON content have the same pattern, you can also try the following way to extract the Company information.

     

    In Power Query Editor, Select the JSON column and then choose add Column From Examples:

     

     

    In the first row of new colum, fill in the Company vaule you want to extract, then Power BI should automatically fill in the other vaules.

     

     

     

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, cesarvinas

You may try to use Add Column->Extract->Text Between Delimiters 

 

Result:

 

Best Regards,

Lin

 

 

  • cesarvinas's avatar
    cesarvinas
    Advocate I
    7 years ago

    Thank you, Lin!! This was also the answer. I've accepted Jessica's one though because I think using the the "column from examples" feature makes it simpler for other use cases too.