Skip to main content
Microsoft Idea

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!