Hi, I'm trying to connect to BigQuery using the native connector I'm getting this error because BigQuery is trying to connect to another dataset that i don't have access to. Does anyone know ...
Sorry to revive an old thread v-jiascu-msft, but I'm having the same issue. Power BI Desktop kicks up an error when it tries to connect to the first project in the list, which I don't have access to and I'm not trying to connect to, despite that when I look in the Advanced Editor there's no reference to that project.
I've tried all the above steps to no avail.
DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (20) Query execution failed: Access Denied: Project REDACTED: The user REDACTED does not have bigquery.jobs.create permission in project REDACTED
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=Table