Forum Discussion

ethan_lunn's avatar
ethan_lunn
New Member
2 years ago

Refreshing Connected Google Sheets

Following error message when refreshing BI with data pulling from google sheets. Occurs intermitently. Have been unable to find a solution after going through both microsoft and google support. Any help would be massivley appriciated. 

 

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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ethan_lunn 

    Based on the error information, this may be due to the fact that too many refresh requests are generated at the same time, resulting in the refresh result not being returned.

    1.please check that whether there are too many data structures in your data source, resulting in multiple refreshes at the same time.  you may consider lengthening the refresh interval.

    2.And you can optimize queries, extract the data that you need and remove other data that don't need.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

    • ethan_lunn's avatar
      ethan_lunn
      New Member
      2 years ago

      Hi Anonymous , 

       

      Thanks for replying to my message. 

       

      I am refreshing a large number of google sheets per refresh. I sometimes get the issue when refreshing an individual sheet however. By lengthening refresh itnerval do you mean not refreshing as often? 

       

      I am considering moving to excel from google sheets as a large amount of sheets need refreshing regularly and this issue is holing up the process. want to try and avoid that by fixing this issue if possible though. 

       

      Thanks,

      Ethan