Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
About twice every week, my data from Big Query will not refresh and I will get this error message:
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. |
Cluster URI: | WABI-CANADA-CENTRAL-redirect.analysis.windows.net |
Activity ID: | 35a960ec-6e65-4f93-872d-c59f1d9c4a4e |
Request ID: | 38547b89-6ef0-c3fb-8640-24718c9a36b6 |
Time: | 2018-06-04 21:25:34Z |
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.