Get data - The length of the string exceeds the value specified for the maxJsonLength property

[HaiVN]

Hello Power BI Community,

I have tried to get data from web ( without API)  and got error message : "An error occurred while serializing or deserializing using the JSON JavaScriptSerializer. The length of the string exceeds the value specified for the maxJsonLength property" Can anyone please help me to overcome this problem?

Thanks!

[PhilipTreacy]

Hi @HaiVN 

So you are receiving JSON?  As you are not doing this via API it must be a regular HTTP request?  If so, try just making the HTTP request in your browser and see what is returned.

Check the returned JSON at either of these sites

JSON Validator - Free Tool To Validate JSON Code Online (jsononline.net)

JSON Validator | Best online JSON checker | JSON Validator (jsonparser.org)

Regards

Phil