Forum Discussion
Anonymous
Dec 18, 2017We 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...
Jedi-X
Aug 04, 2020Copper Contributor
Forever old, but I was trying to ingest an AWS CloudCheckr JSON into Excel via Power Query and getting the "We found extra characters at the end of JSON input."
Finally figured out, with the help of https://jsonformatter.org/ that some data was provided as True -- without quotes, which Excel PQ needed. Simple find/replacing :True, with :"True", did the trick.
Seriously, Microsoft, you did not recognize Boolean when you found it? Excel would have had no problem.