Forum Discussion
Please Help: Suddenly I cannot update my data from the data origin (Google Sheets). JSON ERROR
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.
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.
4 Replies
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.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.
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.
