About twice every week, my data from Big Query will not refresh and I will get this 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 Table: drilldowns_site_and_social_engagement_report.
However, I am not exceeding any limit from Power BI or Big Query. When I run into this issue, I have to manually refresh the data. Sometime, I can try to manually refresh the data 10 times before the error disappears - sometimes it works on the first try. However, this is definitely not because of my data.
This is present on Refresh All in power BI Desktop and all (manual & scheduled) refresh in Power BI Server.