HTTP 429 Error while refreshing data from Google Sheets using R script

[alexmercer]

I have Power BI Pro trial account. One of my reports stopped refreshing the data which I receive via R script from a single Google Sheet. My Power BI is in Russian, so don't mind the Russian words. The strange thing is that when I created the report, it worked fine, but now I cannot refresh the data. The error is:

Load was cancelled by an error in loading a previous table.

DataSource.Error: ADO.NET: R script error.
Sheet successfully identified: "ORMStatsDictionary"
Accessing worksheet titled 'Team'.
Ошибка в function_list[[k]](value) :
  Too Many Requests (RFC 6585) (HTTP 429).
Вызовы: gs_read ... freduce -> withVisible -> <Anonymous> -> <Anonymous>

I'd love to hear some ideas on where to look to fix this.

[alexmercer · Accepted solution]

Hm, tried setting Sys.sleep(30) and the data refreshed.

I guess I just needed way more "sleep". 

[alexmercer]

@v-haibl-msft

I am doing everything in Power BI Desktop. I do not use a personal gateway. It did refresh before. I am not sure at which point it stopped, maybe after I added a couple more queries. In any case, here is what I have:

• 1 google sheet
• 9 queries (data from each of the 9 tabs inside the spreadsheet)
• R code for each query looks like this:
  

  library(googlesheets)
  setwd("[PATH to working dir]")
  gs_auth()
  x <- gs_key("[google sheet key]")
  data <- gs_read(x, ws = "[Tab name]")
  Sys.sleep(10)

I added the Sys.sleep after reading the link you have in your post (found it before). It did not help.

One other thing, the error pops up while in Evaluating stage. 4-5 of them change to "waiting..." and the error appears:

[v-haibl-msft]

@alexmercer

Did your report refresh well before, or it has never refreshed successfully after published to Power BI Service? Are you using the personal gateway?

Please also take a look at this page to see if it helps.

Best Regards,
Herbert