Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

rw-brusnika

Refresh BigQuery data(error)

Submitted by on ‎05-05-2018 11:55 AM

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 quota for api requests per user per method. 

 

Cluster URIWABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID67a3881e-e6af-ac24-ef72-993f1e887bf7
Request ID0a518bce-f399-a97f-06b7-305d62b00daf
Time2018-05-05 18:53:40Z

 

Im not reach any big query limits.

 

Status: New
See more ideas labeled with:
30 Comments (30 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-07-2018 12:01 AM

Hi @rw-brusnika,

 

There is a limitation on Big Query side: 

 

API requests per second, per user — 100
Concurrent API requests, per user: 300

 

Please ensure you don't hit this limitation, see: https://cloud.google.com/bigquery/quotas#api_requests

 

Also please try to refresh in Power BI desktop for the same report to see if any error occurs. 

 

Best Regards,
Qiuyun Yu 

iyadaqel
Frequent Visitor
‎05-07-2018 01:55 AM

Hi @v-qiuyu-msft

 

I'm having the same issue as above, and i'm only fetching a couple of rows from 3 different tables. 

Its weird that when i referesh from the PowerBI Desktop i'm not having any issue, but when i'm refreshing from the Web app i'm having the issue. It seems like a bug in the  web app? 

rw-brusnika
Regular Visitor
‎05-09-2018 03:16 AM

Hi @v-qiuyu-msft

This error repeat on power bi desctop when im try refresh all big query tables.

How i can solve this problem?

danzrust
Helper IV
Helper IV
‎05-13-2018 10:59 AM

Same here. The issue started only recently.

 

I can get this message 20 times when trying to refresh. Then I refresh for 21st time and it goes through.

 

Not sure where the problem is but it's super annoying.

 

DZ

iyadaqel
Frequent Visitor
‎05-14-2018 10:49 PM

@HI @v-qiuyu-msft 

based on everyones input, do you think we should report this as a bug? 

Anonymous
Not applicable
‎05-24-2018 11:36 PM

We are experiecing the same issue.

Further, the request cannot be seen in the Google Cloud Console, where I would have expected it to show as an error due to quota limitations.

Anonymous
Not applicable
‎05-25-2018 12:39 AM

I am having a similar issue. This is the first time I am trying to connect since installing PowerBI.

 

Details: "ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Peer certificate cannot be authenticated with given CA certificates
ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Peer certificate cannot be authenticated with given CA certificates"

bartvandervurst
Regular Visitor
‎05-30-2018 06:43 AM

We experience the same Issue since 2 weeks: sometimes the refresh works; most often it doesn't. 
How can we solve?

Dominaky
Frequent Visitor
‎07-25-2018 08:11 AM

Same thing here. Breaks my automatic refresh about once a week. Has anyone report this yet?

danzrust
Helper IV
Helper IV
‎07-25-2018 08:52 AM

My 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

 

 

 

Idea Statuses