Pivot json data: missing data?



I am loading data from a JSON file into a Pivot table. I’m noticing it is not displaying all of the data present in the file. It is all well-formed JSON. Anyone experience anything similar?

Thank you!


Could you please, provide a problematic JSON file or a complete demo/demo link, where the problem could be reconstructed locally.


Also, please, check that you have no duplicating ids in your JSON.