Update error - 429): Too Many Requests

[Anonymous]

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:

[Jord]

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.

[GilbertQ]

Hi @Anonymous 

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