Google BigQuery Data Rate Error

[mdmoo]

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]

Hi @mdmoo,

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

Best Regards,

Dale