Getting DataFormat.Error: We found an invalid character between object key and value in JSON input

[PowerBI88]

Hi,

both in Power BI Desktop and from the Power BI Service I am getting the following error: DataFormat.Error: We found an invalid character between object key and value in JSON input. when calling a web service.

This is the web service call:= Json.Document(Web.Contents("https://eglprod.service-now.com/api/now/table/change_request?sysparm_query=sys_created_onRELATIVEGT%..."))

Any hint on how to solve this issue? The service takes 1 minute to respond, can slow response cause this issue?

Thank you

Kind regards

Marta

[v-henryk-mstf]

Hi @PowerBI88 ,

According to your description, check if the following related solutions are helpful to you.

Solved: Transform content to JSON is not working - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PowerBI88]

Hi, the link did not help unfortunately. The message error is the one shown in the picture and in the post title. 

Kind Regards

Marta

[PowerBI88]

In addition I've checked the returned json by means of a validator and it results valid.