BigQuery connector trying to connect to the wrong project!

[leobiagio]

Hi, I am trying to connect to a BigQuery dataset, but the connector returns an error, it says my username does not have access to the project starry-braid-156516, BUT I was not trying to connect that project, I do not even know what project it is!!

I have already checked the Advanced properties in the query editor and the following is the example of when I try to connect to a public BigQuery dataset:

let
Source = GoogleBigQuery.Database(null),
#"bigquery-public-data" = Source{[Name="bigquery-public-data"]}[Data],
baseball_Schema = #"bigquery-public-data"{[Name="baseball",Kind="Schema"]}[Data],
games_post_wide_Table = baseball_Schema{[Name="games_post_wide",Kind="Table"]}[Data]
in
games_post_wide_Table

The error is the following:

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (20) Query execution failed: Access Denied: Project starry-braid-156516: The user leonardo.biagioli@gmail.com does not have bigquery.jobs.create permission in project starry-braid-156516.
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=Table

Could you please help me? I know that it is still in beta but it is supposed to work, at least to connect to the correct project....

Thanks,

Leonardo

[leobiagio]

Screenshot of the error here: https://drive.google.com/open?id=1lhFICw6gNvlE63XBcX9kxDMolSYk0OgC

[v-jiascu-msft]

Hi Leonardo,

Please mask your sensitive data.

The BigQuery connector works fine in my test. Please check these things below.

1. Upgrade Desktop to the latest version:  2.52.4921.682 (November 2017).

2. Check your BigQuery settings. starry-braid-156516 could be project id.

3. Connect to BigQuery using a user with the owner Privilege.

How can reproduce this issue?

Best Regards,

Dale

[leobiagio]

Answering by point.

1. Upgrade Desktop to the latest version:  2.52.4921.682 (November 2017). --> I have already the latest version, I have the 64bit installed

2. Check your BigQuery settings. starry-braid-156516 could be project id. --> I know that starry-braid-156516 is a project id but as you can see I am trying to connect to a public dataset, and the project id is bigquery-public-data.... Moreover, in the list of my projects, I do not have any starry-braid-156516 project...

3. Connect to BigQuery using a user with the owner Privilege. --> The owner privilege where? On the BigQuery project? I am trying to connect to a public dataset, I can not be owner of that project! If I try to connect to one of my private projects where I am owner, Power BI tries to connect to starry-braid project the same way....

[v-jiascu-msft]

Hi @leobiagio,

Are you the owner of Project starry-braid-156516? Are there any other users in your project? Including different accounts but owned by you.

Best Regards,

Dale