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?
