Connection error for Google BigQuery Service Account Login - Access Denied

[lfrazzoni]

Hi all,

sometimes (not always) I receive a connection error to Google Big Query (I'm using Service Account), but I don't understand why.

Quick intro:

On my Power BI Desktop, when I'm crearting the new BigQuery connection, I see three different project:

• ProjectA
• ProjectB
• ProjectC

I've got permissions only for ProjectA because I have all my tables there.

I've made the connection and I've choseen the tables of ProjectA without problems, but sometimes I receive an error during the refresh (both on Desktop and Service): "Access Denied: Project ProjectB".
It's correct that I don't have access to ProjectB, but all my tables are in ProjectA. I don't understand why sometimes the refresh works, and sometimes doesn't.
I published the report and the dataset on PBI Service and, once again, the refresh works intermittently.

This is the error:

DataSource.Error: <ccon>ODBC: ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: Access Denied: Project ProjectB: User does not have bigquery.jobs.create permission in project ProjectB.. DataSourceKind = GoogleBigQuery. DataSourcePath = GoogleBigQuery. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). </ccon>. The exception was raised by the IDbCommand interface. Table: Table1.

This is the Refresh History on PBI Service (all with the same Service Account Login and without any changes):

Feel free to ask any information you need. 

Thanks for the help.

Luca

[lfrazzoni · Accepted solution]

I think it's a connector bug, I've solved reducing visibility in the service account to just Project A.
I still don't understand how I can receive error on a table that I'm not using.