Parsing JSON using Json.Document in Power Query

[zamponi10]

Hi, 

I am trying to transform some data using the function Json.Document in Power Query. 

I am getting an error when parsing the content of row 51.

Here is the image of the error.

I investigated the JSON of row 51 and found no problem with the JSON. 

Hence I deleted the first 45 rows of the table (row 51 bacome row 6) and try to parse the content again. 

Row 6 was now parsed correctly. 

Are there limits in the Json.Document function that make this behavior understandable? Is there a way to avoid the first error?

[zamponi10]

I would like to add some details:

- I am using an ODBC connector to pull data from Mongo DB

- the JSON I am trying to parse is automatically generated from a view of Mongo DB

- The view contains 68 elements and I get an error only on the element 51

- I did not find any error on the JSON  of the position 51

- I deleted the first "x" rows of the dataset 

- the dataset is now 68-x rows

- The data is now in position 51-x and it is parsed correctly

Can you help me explaining this behavior?

[zamponi10 · Accepted solution]

I solved the problem reducing the lenght of the json that I was importing in Power Query. 

It looks like that the json get automaticcaly truncated by the funtion josn.document, if is too long. 

I did not understand the rule of truncation.