Forum Discussion

LexBolkesteijn's avatar
LexBolkesteijn
New Member
9 years ago

DataFormat.Error: We found extra characters at the end of JSON input.

Hello all, Been working around for a few days with PowerBI now and got a lot of stuff working allready.  Have used variouse Visualzations and connecting to large volume SQL Server, Azure SQL datab...
Need Help
LexBolkesteijn's avatar
LexBolkesteijn
New Member
9 years ago

Tested it today also for Azure blob storage. Same problem.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi everyone!

     

    I modified the JIRA content pack and I'm having the same error when I upload to online.
    Is there any news about this error?

    Thanks!

  • DolEgon22's avatar
    DolEgon22
    Advocate II
    9 years ago

    Four months later and nobody has responded to this. We're running into the exact same issue when using Azure Blob Storage as a datasource (even CSV). 

     

    DataMashup.Trace Warning: 24579 : {"Start":"2017-08-14T19:17:20.5789351Z","Action":"SimpleDocumentEvaluator/GetResult","HostProcessId":"17348","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataFormat.Error] We found extra characters at the end of JSON input.\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Json.JsonParser.Parse(JsonTokenizer tokenizer)\r\n   at Microsoft.Mashup.Engine1.Library.Json.JsonModule.Json.DocumentFunctionValue.TypedInvoke(Value jsonText, Value encoding)\r\n   at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)\r\n   at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(MembersFrame1& frame)\r\n   at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(MembersFrame1& frame)\r\n   at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(MembersFrame1& frame)\r\n   at Microsoft.Mashup.Engine1.Language.ExpressionInvocationExpression2.Execute(MembersFrame1& frame)\r\n   at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(MembersFrame1& frame)\r\n   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)\r\n   at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)\r\n   at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)\r\n   at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)\r\n   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()\r\n   at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.Force(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.get_Item(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)\r\n   at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)\r\n   at Microsoft.Mashup.Engine1.Language.Expression.ExecuteCondition(Value frame)\r\n   at Microsoft.Mashup.Engine1.Language.DebugExpression.ExecuteCondition(Value frame)\r\n   at Microsoft.Mashup.Engine1.Language.IfExpression.Execute(Value frame)\r\n   at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)\r\n   at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)\r\n   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()\r\n   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)\r\n\r\n\r\n","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"e683962d-0763-4d48-978f-e63be7e527c8","Process":"Microsoft.Mashup.Container.NetFX40","Pid":12636,"Tid":1,"Duration":"00:00:00.0200926"}