Skip to main content

Issues

Completed

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

Vote (1) Share
Saurabh Agarwal's profile image

Saurabh Agarwal on 10 Aug 2016 02:25:25

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."
}
]
}
}

Comments (2)
Saurabh Agarwal's profile image Profile Picture

sadf sdf on 05 Jul 2020 22:27:45

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

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/

Saurabh Agarwal's profile image Profile Picture

Saurabh Agarwal on 05 Jul 2020 22:27:18

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

Hi,

Anyone? Is JSON parsing in PowerBI supported when the fields are lists?

Thanks!