Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I looked at this thread already: https://community.powerbi.com/t5/Desktop/We-found-extra-characters-at-the-end-of-JSON-input/m-p/2069....
The first 2 lines of my input look like this (... is omitted data):
{"_index":"data","type":"hnw_user","_id":"100004477389220",...,"locale":"vi_VN","phone_number":"8496109...6"}}
{"_index":"data","type":"hnw_user","_id":"100013993450651",...,"locale":"vi_VN","phone_number":"8496109...1"}}
The last 2 rows looks like this:
{"_index":"data","_type":"hnw_facebook_user","_id":"100003943749285",...,"website":"","about_me":"","quotes":"","relationship_status":"Married","cell_phone":"","other_phone":"","contact_email":null,"timezone":null}}
{"_index":"data","_type":"hnw_user","_id":"100011776416175",...,"locale":"vi_VN","website":"","about_me":"","quotes":"","relationship_status":"","cell_phone":"","other_phone":"","contact_email":null,"timezone":null}}
I got the message "We found extra characters at the end of the JSON input"
I cannot change to .txt and treat this file manually because there are many inconsistencies in the data. For example in some cases I will have:
...,"hometown":{"city":"XXX","state":"YYY...
some other case:
...,"hometown":[],...
I cannot plug this file into some online JSON checker because its size is larger than the limits allowed by most of these sites.
Could some JSON expert tell me if this file has the right syntax from the looks of the 4 rows given above?
Solved! Go to Solution.
Thanks for your ideas. I found the solution. I added [ at the beginning, ] at the end, and , after every line. Cuz this was a multi-dimensional JSON file.
Thanks for your ideas. I found the solution. I added [ at the beginning, ] at the end, and , after every line. Cuz this was a multi-dimensional JSON file.
@freelensia , refer old solution for any help and idea
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |