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 [email protected] 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
5 Comments
Screenshot of the error here: https://drive.google.com/open?id=1lhFICw6gNvlE63XBcX9kxDMolSYk0OgC
v-jiascu-msftMicrosoft Employee
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
Vicky_SongImpactful Individual
Status changed:NewtoNeeds InfoAnswering 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
