JSON Parsing gives "Reached End of Buffer" error in PowerBI

[saaga]

Summary: I have a error field that is a JSON (Nested). I use Transform->Parse->JSON to parse the column with the JSON. It works as expected but when it reaches a node where the field (details in the example below) is a LIST, then upon trying to expand that column (LIST), I get an error: DataFormat.Error: We reached the end of the buffer. Can you please tell me if there is a support to expand lists? { "status": "Failed", "error": { "code": "XYZ", "message": "Message_1'.", "details": [ { "code": "Timeout", "message": "Message_2." } ] } }

[saaga]

Hi, Anyone? Is JSON parsing in PowerBI supported when the fields are lists? Thanks!

[chass]

Yes this is supported and you can see me doing it here: https://blogs.msdn.microsoft.com/charles_sterling/2016/06/15/calling-rest-apis-and-parse-json-made-simple-with-power-bi/