Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can create a support ticket in the end of the support page:
About tracing Power BI, see:
Best Regards,
Community Support Team _ Yingjie Li