Im try refresh my Big Query data And im get this error message MessageERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Exceeded rate limits: Your user_method exceeded q...
Wow I am amazed at how bad this bigquery connector is. First I had problems because powerBI said it couldn't see the tables (even though connecting through desktop was problem-free), and now I get this error about quota's that I'm pretty sure I'm not exceeding (or at least google doesnt show it in their reporting) and of course it works flawless in powerBI desktop.
But I guess it's now a year later and still no fix. I just think that the PowerBI team need to admit that their BigQuery connector is not reliable and remove it from the options. I spent several weeks creating reports based on the bigquery/powerbi combination and now I'm kind of finding out that it doesnt work reliably at all.
Very frustrating 😞