NEW BUG: Bigquery connection error - DataSource.Error: ODBC: ERROR [42000] [Microsoft][DSI]

[Cob_Adm1]

Hi All,

I have some qeird error in my PowerBI. When I try to connect to the bigqeury views I get this error:

DataSource.Error: ODBC: ERROR [42000] [Microsoft][DSI] An error occurred while attempting to retrieve the error message for key 'GApiErr' with message parameters ['Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.'] and component ID 100: Message not found in file "C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Google BigQuery ODBC Driver\en-US\SimbaBigQueryODBCMessages.xml"
Szczegóły:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=[Table]

The problem is that it works for some views and I got this error for other views, there is no pattern like different naming etc.

Also I reinstalled PowerBI, tired to use previous versions, tried on a different company computer, changed permission rights, tried different connections etc. but without success.

I also checked it using different users with windows and it is exactly the same. Cleaning cache does not work as well.

At the beginning I thought that it may be related to the latest windows update, but I removed all the windows updates and it is still not working.

Any ideas what the error is or how to solve it?

[tabar]

Hi! Since today I get this error for all my BigQuery imports. Could somebody please help?

[jonaseikanger]

@Cob_Adm1 

Did you manage to solve this issue? 

[jonaseikanger]

@Anonymous  / @TatiparthiKiran 

I face the same issue and I did not fully understand your solution. Could you provide some screenshot or describe a bit more in detail?

Had this issue for two weeks now without any soluton so this would be much appreciated!