Forum Discussion

tkramer's avatar
tkramer
Advocate I
2 years ago

Google Sheet Connector

I am having trouble connecting to data on Google Sheets. Here is the error:

Web.Contents failed to get contents from 'https://sheets.googleapis.com/v4/spreadsheets/CTrTkX99999999999?fields=sheets/properties,namedRanges' (429): Too Many Requests

 

This is a very small table (8k rows) and we have no other queries connecting via Google Sheets (this is the first time I am trying).  I am using the "share" link on Google Sheet.  Has anybody else ran into this and have a solution?  
Need Help

1 Reply

  • cpwebb's avatar
    cpwebb
    Microsoft Employee
    2 years ago

    Can you share the full M code for the Power Query query that you're using? It looks like Google Sheets is raising this error because your code is making too many requests in too short a time period. Wrapping the call to get data from Google Sheets with Table.Buffer or adding delays between calls using Function.InvokeAfter (see https://blog.crossjoin.co.uk/2015/04/30/using-function-invokeafter-in-power-query/ for example) might help avoid this error.