Forum Discussion
We Found Extra Characters at End of JSON Line
Using the JSON files provided on the Yelp website, https://www.yelp.com/dataset. When attempting to connect to the files via Excel's "Get Data" or Power BI, and error message appears stating "We fou...
Ron, I guess you forgot to separate records by comma. Please see files in my previous post.
Sergei,
You are absolutely correct.
Used Sublime Text to edit my JSON file to add the header and footer lines, plus the commas at the beginning of each new line as you suggested. I then attempted a connection to the edited JSON file via Excel. This time, success!
Thank you!!
Can you please shore this solution in pictures with me. i am facing same error.
