Forum Discussion
Parsing JSON using Json.Document in Power Query
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.
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?
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.