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