SQL Error in CREATE TABLE as SELECT

[rosita_sengsey-]

Hi.

I have received this error. All datasets under the project is located in the US except one dataset. Can this be the reason?

I have also the right permission for the whole project and datasets.

See below for the error.

The Google BigQuery Standard SQL database encountered an error while running this query.

derived_table gcp_billing_export creation failed: SQL Error in CREATE TABLE as SELECT: 403 Forbidden GET https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-all-customers/queries/1a2928c9-937d-4d65-9484-5dac835be169?location=US&prettyPrint=false { "code" : 403, "errors" : [ { "domain" : "global", "message" : "Access Denied: Table instance:billing.gcp_billing_export_public: User does not have permission to query table instance:billing.gcp_billing_export_public, or perhaps it does not exist in location US.", "reason" : "accessDenied" } ], "message" : "Access Denied: Table instance:billing.gcp_billing_export_public: User does not have permission to query table instance:billing.gcp_billing_export_public, or perhaps it does not exist in location US.", "status" : "PERMISSION_DENIED" }

Thanks

Rosita