cancel
Showing results for 
Search instead for 
Did you mean: 

Refresh BigQuery data(error)

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
Comments
Visitor

 

Hi Steffen 

 

thanks for sharing your story with us.

 

To be honest i think the issue it's not on the google BQ side, as i don't see any spike or quota limit when i go to our google console after the error occurs on PowerBi.

 

There's also que question that this issue on our end only happens on PowerBi service, on PowerBi desktop it works fine. 

 

As i've said before i think Powerbi team messed up this time, releasing a conector that doesn't do what it should and this is a big issue for us. The worst is that there's no ETA to solve this and it's hard to make a proper data and reporting strategy with this level of uncertainty.

 

 

 

 

 

 

Regular Visitor

@SteffenDavidsen Thanks for your reply. I actually downloaded Simba but haven't poked around much. My issue is that I don't know the SQL syntax required to replicate the qeueries. Does Simba require knowledge of syntax or is it more of a drag and drop interface?

Regular Visitor

@joshpt 

 

Agreed. It's honestly ludacris that this would be an issue and that it hasn't been acknowledged. 

Visitor

@lemarcfj i still don't get why do you need SQL to use direct query. The direct query funcionality that Powerbi has, what does is to retrieve the information from BQ everytime you refresh the report. The way you create the bridge between PowerBI and BQ is the same.

 

There are some issues with this approach in terms of BQ costs and for that you may need to review the data structure you have on BQ. 

What i did here was to create some views that go directly to the raw data (for this you need to know SQL). After i've scheduled this view to dump the results on a table and this table it's then consumed by powerbi.

 

 

 

 

Visitor

I have the same error

 

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. 

 

Are there any updates on the BigQuery connector?

Frequent Visitor

@joshpt - I don't disagree with you. Adding a pre-build connector, that works as bad as this one, is ridiculous. However, I believe the issue is not limited to Power BI. The error description is clearly generated in BigQuery - and we should be able to see the rejected call in the cloud console. Clearly, both Microsoft and Google have to dig into this issue, if they want their systems to interact.

 

 

@lemarcfj - The ODBC driver generally works like the pre-build connector. The only technical difference is, that you have to set it up and install a gateway on the server. It does not eliminate the quota errors, but it greatly reduced them.

 

Visitor

Hi @SteffenDavidsen

 

thanks for your comment but i still don't see anything on my google cloud console after the refresh fails. 

 

The only issue is the PowerBi Service (Cloud) but sometime it works on weekends. On PowerBi desktop i've never had an issue refreshing the data. This is why i assume the issue resides in the Powerbi connector and has nothing to do with Google BigQuery. The only thing that comes in my mind is google detecting that a lot of requests are being made from the same ip/machine that makes several calls at the same time, but uses diferent credentials.

 

It shoudn't be an easy task otherwise powerbi team already have sorted that out. This thread it's been around for some time already. 

 

@giusvizz the last time i've got an answer from microsoft, was told me that they are thinging on a solution for this but there's no ETA for this. Besides that i don't have another info.  Which i would...

 

 Best