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!

[khajahussain]

The error you are seeing is because, you are trying to load data which is kind of too large for the default limit in Power BI's web connector. try to reduce the data size. Use query string to fiter our unwanted data. You can paste your JSON into a tool like JSON Reader tool to make sure it's valid and to preview its structure.

[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