cancel
Showing results for 
Search instead for 
Did you mean: 

BigQuery Based Datasets No Longer Refreshing

Hi guys,

we are using Premium service and since last week (from 2021-02-26 to be more accurate), my BQ based dataset stopped refreshing in the service.

 

I see 2 errors.

 

danzrust_1-1614937019486.png

 

The project IDs mentioned in the screenshot above are not really the ones from where the data is supposed to be pulled. My project IDs have nice user friednly names. I don't know where "avast.com:api-project-267....................." is coming from all of the sudden.

The second issue I am having is this:

danzrust_2-1614937158061.png

The thing which I don't understand here is the fact it's mentioning Simba ODBC. I am not using ODBC in my dataset. I am using the default "Google BigQuery" connector which is available in Power BI for Desktop. 

 

Any ideas how to get around this? 

 

Seems like BigQuery connectors are quite unreliable. Major issues happening every 2 months or so. 

 

 

 

Status: New
Comments
danzrust
Helper III

With regards to the second issue. I was able to isolate the moment of failure. 

 

When I download inside 1 dataset:

1 BigQuery table

A csv from public URL

Data from internal SQL Analysis Services

... and do nothing with these (=no transformations), then I am able to publish to service and even refresh the dataset in the service.

 

However, when I append all the 3 sources into one table in the PQ editor and then publish to service, then it start throwing the error on the gray background.

v-lili6-msft
Community Support

hi

As the error mentions, please contact your admin that if you have bigquery.tables.list permission foer the project in Google BigQuery. There is more information about permission control in this article:https://cloud.google.com/bigquery/docs/access-control.

also refer to this post:

https://community.powerbi.com/t5/Power-Query/Error-Interacting-with-REST-API-while-connecting-to-Goo...

 

 

there is an issue for BigQuery connector and and it is fixed in 2.3.0.1001.

please navigate to this folder on their Power BI Desktop machine:

C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Google BigQuery ODBC Driver

Right-click on the file GoogleBigQueryODBC_sb64.dll, and choose properties.

Switch to the Details tab, and see what the File version is.

If it's 2.3.0.1001 - it has the fix.

 

Regards,

Lin

danzrust
Helper III

Regarding permissions - I am Google Cloud project owner and BQ admin. It cannot get any "better" for me. 

 

Regarding Simba - I'm actually running 2.3.1.1001 which sounds like an even newer version compared to what you are mentionning?

 

EDIT:

I reinstalled whole Power BI and I'm still getting 2.3.1.1001:

danzrust_0-1615197581584.png

 

Btw, I still don't see how bad Simba ODBC could have an impact on the refreshes in the services (failing) while the dataset on desktop would refresh OK.

 

DZ

 

 

danzrust
Helper III

Anyone?