Forum Discussion

nywi6100's avatar
nywi6100
Frequent Visitor
7 years ago
Solved

JSON Transformation Error

Hi all. I am getting data from a Sharepoint Online List. It has several fields and one is in JSON format. When I transform it I can expand it. I click to expand, then again and expand to new rows. I ...
Need Help
  • nywi6100's avatar
    nywi6100
    7 years ago

    I found the solution. I brought the column in three times. Once for each component of the JSON. Then I parsed each column picking a different component. Worked like a charm. The issue seemed to be in going from one single column of JSON where there is more than one column on the output. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

nywi6100,

Is there any possibility that you can export the JSON field to a flat  JSON file so that I can test? Or you can use JSON connector in Power BI Desktop to connect to the exported JSON file and check if the error still occurs.

Regards,

Lydia

nywi6100's avatar
nywi6100
Frequent Visitor
7 years ago

I found the solution. I brought the column in three times. Once for each component of the JSON. Then I parsed each column picking a different component. Worked like a charm. The issue seemed to be in going from one single column of JSON where there is more than one column on the output.