Error when consuming JSON Form Web data source

[AndyBrew]

Hi,

Just testing Power BI's ability to connect to a From Web Json data source and all of a sudden I'm getting the error: -

"We found extra characters at the end of JSON input."

This is my raw Json exactly as it is returned from my Test API: -

{"Table1":[{"Id": "1"},
{"Id":"2"},
{"Id":"3"}
],"Table2":[{"Id":"3"}
,{"Id":"4"}
,{"Id":"5"}
]}

 This is the error from the trace dump: -

DataMashup.Trace Warning: 24579 : {"Start":"2020-02-18T09:08:03.2333789Z","Action":"StreamMessenger/Read","Exception":"Exception:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Unable to read beyond the end of the stream.\r\nStackTrace:\n   at System.IO.__Error.EndOfFile()\r\n   at System.IO.BinaryReader.FillBuffer(Int32 numBytes)\r\n   at System.IO.BinaryReader.ReadInt32()\r\n   at Microsoft.Mashup.Evaluator.MessageSerializer.Deserialize(BinaryReader reader)\r\n   at Microsoft.Mashup.Evaluator.StreamMessenger.Read()\r\n\r\n\r\n","ProductVersion":"2.76.5678.782 (19.12)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":35344,"Tid":1,"Duration":"00:00:00.0009399"}

 Whilst import requesting the data I get the following: - 

[v-easonf-msft]

Hi , @AndyBrew 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or your reply as Answered to close this thread?

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi , @AndyBrew 

Here are two posts I searched. I don't know whether it will work for you. 

https://stackoverflow.com/questions/39331013/excel-2016-json-web-query-extra-characters-at-the-end-o...

https://stackoverflow.com/questions/40233654/importing-multiple-json-files-to-powerbi-what-format-do...

Best regards ,

Eason

[mwegener]

Hi @AndyBrew,

is there a non-printable character at the end?

Try Text.Trim to remove such characters

https://docs.microsoft.com/en-us/powerquery-m/text-trim