Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Update error - 429): Too Many Requests

Hi guys

 Could someone help me with the problem bellow. In lasts weeks my PBI reports began the error (429): Too Many Requests. DataSourceKind = GoogleSheets. DataSourcePath =. I Checked my batabases and I didn't found any problem there, It's databases tha I alweys had and never have problem before. 

Find bellow the print:

 

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi Anonymous 

     

    It could be that the spreadsheet is too big and the Google sheets API might have a limit?

  • Jord's avatar
    Jord
    Frequent Visitor
    2 years ago

    Hello,

    I had the same problem in power bi reports that consume data from google sheet, searching I found this link to the google documentation: "https://developers.google.com/sheets/api/limits?hl=pt-br".
    I managed to solve the problem by migrating the spreadsheet to Microsoft OneDrive and changing the connection in Power BI Desktop so that instead of connecting to Google, it connects to Microsoft OneDrive.