cancel
Showing results for 
Search instead for 
Did you mean: 

Google Bigquery connections no longer working in PowerBI Service

Hi there, 

 

since today I started experiencing connectivity issues in PowerBI service when connecting to some of my views in BigQuery. This was working mere hours ago. Also in desktop this works just fine.

 

The error message is the following:

ODBC: ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API: Couldn't connect to server ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API: Couldn't connect to server Table: DimLesson.


I don't know what has changed. I just know that all my refreshes on service are failing now. The latest successful refresh was at 2:57.

Help!

 

Jaap

Status: New
Comments
Moderator

Hi @Jaap_Olsthoorn

 

Please spread out the refresh schedules to avoid overlaps to check if the same issue occurs. See: https://community.powerbi.com/t5/Service/REST-api-to-google-big-query-crashes/td-p/800366

 

Best Regards,
Qiuyun Yu

Member

That is interesting. So the refreshes I do all come from views, but those views are connected to the same table. Could that be what is causing it? Not sure how to fix that though...

 

And if this was the problem, do you have an explanation of why it works flawlessly in powerbi desktop? It also seems way more reliable in a dataflow (0 failures in 4 refreshes so far)

 

Thanks!