Accessing Cross-Project BigQuery Datasets

[IP Digital]

Hello ,

I have a Cross-Projects Issue with a Bigquery Data Set.

I have a nodejs Google Cloud Console project I will call him P1.

P1 needs to have access to a bigquery dataset from another Google Cloud Console project, i will call it P2.

If in the console I test my project by doing "NPM START" and a "web preview"...it's perfect, no issue but If I deploy my projet ....I always has this error when I want to make an insert in the dataset --> 

"reason": "accessDenied"

"domain": "global",

2021-05-12 16:45:58.000 HAEC

"message": "Access Denied: Dataset ipb-xxx:yyyyy: Permission bigquery.datasets.get denied on dataset  ipb-xxx:yyyyy:   (or it may not exist).",

I granted a P1 service account in the IAM on P2, and give him the "Bigquery Admin"  and event "owner" but no way...

I do not understand what I missed....

Any idea is more than welcome.

Thanks.

Nicolas

[George (Cloud Platform Support)]

There are more ways to grant access to a BigQuery dataset, in excess of the service account, you may check point 3 in the Granting access to a dataset sub-chapter. It may prove worthwhile going through the console tab and verify that all steps have been followed.