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  [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.