Parse json option is greyed out

[Eduardo_Royo]

We are connecting to Odoo with a connector (https://github.com/tmijail/Odoo-Power-BI-Connector) and its working fine, except for the table account.move.line (invoice lines) and field analytic_distribution, which is coded in JSON.
According to the documentation (https://learn.microsoft.com/en-us/power-query/parse-json-xml), it is possible to parse the field, but in this case, with the column selected, all text options are

We are connecting to Odoo with a connector (https://github.com/tmijail/Odoo-Power-BI-Connector) and its working fine, except for the table account.move.line (invoice lines) and field analytic_distribution, which is coded in JSON.
According to the documentation (https://learn.microsoft.com/en-us/power-query/parse-json-xml), it is possible to parse the field, but in this case, with the column selected, all text options are greyed out (see screenshot).

.

[Anonymous · Accepted solution]

Hi, @Eduardo_Royo 

The Parse text as JSON or XML function is available in the column type Non-Record, as shown in the following figure:

When each row of a column is of type record, the Parse text as JSON or XML feature is not available:

This function is mainly to convert text-based JSON to record, as shown in the picture above. In picture 2 are the columns that have been converted to JSON. 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.