Please Help: Suddenly I cannot update my data from the data origin (Google Sheets). JSON ERROR

[BrunoMedrano]

I have the following message in Power Queery: DataSource.Error: No se ha podido recuperar el contenido de la página web.

ErrorMessage=Error durante la serialización o deserialización mediante JavaScriptSerializer de JSON. La longitud de la cadena supera el valor establecido en la propiedad maxJsonLength.
Nombre del parámetro: input

It is in spanish by the way. This was such a bad thing for me because I ve never had this issue before. If someone can help me I would be very grateful.

[Ehren]

Thanks for reporting this. This is a bug in the new "Web connector infrastructure update" preview feature, which occurs on pages over a given size limit.

We'll be fixing it, but in the meantime you can work around the bug by unchecking the "Web connector infrastructure update" preview feature.

[v-jingzhang · Accepted solution]

Hi @BrunoMedrano 

I noticed that you are using Web.BrowserContents() to connect to Google Sheets and extract table from Html. Can you try using the built-in Google Sheets connector to get data from the same sheet file? It uses GoogleSheets.Contents() instead and probably doesn't have this problem. 

Power Query Google Sheets connector - Power Query | Microsoft Learn

Json result have some default length. Whenever it exceeds, it throws the error "The length of the string exceeds the value set on the maxjsonlength property". I don't find where we can modify the maxJsonLength property for Power BI and I'm not sure whether this is possible. I think using the Google Sheets connector may be a workaround.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[BrunoMedrano]

Thank you very much Jing Zhang. The issue was just as you said. I had to go to Power query and tried to change the query, specifically the command to import data (Web.BrowserContents()), and changed it to = Excel.Workbook(Web.Contents( . After playing around, and try and failure, I managed to write a good script that succesfully ran my data.

[Anonymous]

I have the same problem with a google forms database, please help