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.
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: -
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
Hi , @AndyBrew
Here are two posts I searched. I don't know whether it will work for you.
Best regards ,
Eason
Hi @AndyBrew,
is there a non-printable character at the end?
Try Text.Trim to remove such characters
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 |
---|---|
109 | |
101 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |