Im try refresh my Big Query data And im get this error message MessageERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Exceeded rate limits: Your user_method exceeded q...
danzrust
Helper IV
8 years agoMy observation is that I get this error in very complex datasets with many merges & appends when the source tables sit in Big Query.
When I refresh simple datasets with no lookups/appends, I am able to download even 50M rows from Big Query tables via Power BI with no issues.
DZ