Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Google sheets connector always worked great, never had any issues till now. However since some update in late 2023 yearly 2024 I have been getting this 429 error message stating too many requests were being made and the data simply will not load.
I Came to a point when testing this behavior that simply connection to a single sheet with 50 rows returns me this error. so i know the number of sheets connected or the number of rows has nothing to do with it.
I have to keep trying and without changing anything at some point it will simply accept and fetch the data normally. But that turns my refreshes unusable, since they are not reliable and i have to keep refreshing them by hand in order to try multiple times.
I have seen many users reporting similar issues, but no real solution provided until now.
If you work with too many sheets some people say to join them all in a single sheet (but as stated that is not the issue here, since a since sheet with 50 rows will get the same error), googles documentation said to do a Exponential backoff but that cannot be done in pwoerquery (you could do by programming an api but not through power query) and there is no way to increase the limit eitehr by sheets side or PBIs side.
The bulk of the data releis on sheets and this weird behaviour ends up making impossible to use powerbi as is
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Nevsksar
If you exceed a quota, you'll generally receive a
429: Too many requests
HTTP status code response. If this happens, you should use an exponential backoff algorithm and try again later.Usage limits | Google Docs | Google for Developers
Best Regards,
Community Support Team _ Ailsa Tao