Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.