Google BigQuery Data Rate Error

mdmoo · ‎09-07-2018

I have a number of reports that are loading data from Google BigQuery and not everytime, but most of the time they get the following error:

Message: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Exceeded rate limits: Your user_method exceeded quota for api requests per user per method. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors

I'm not 100% sure this is really a PowerBI issue, but since I am able to do the refresh on the desktop I believe that it is both a Google BigQuery and PowerBI issue. On the Desktop verision I got around this by disabling parallel table loads, but that doesn't seem to help with the service based refreshes.

Does anyone have experience working through this?

v-jiascu-msft · ‎09-09-2018

Hi @mdmoo,

Please refer to bigquery/quotas and check if the refresh request exceeds the limits.

Best Regards,

Dale

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