Forum Discussion
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 =...
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.
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.