union of 2 views with different data set loations in bigquery database

[vidhyaravi]

i am trying to create a union with 3 database views under derived table with 2 of them with dataset location “europe-west”  and one with dataset loation “US”. now when i try to create a report i get an error “The Google BigQuery Standard SQL database encountered an error while running this query.

Query execution failed: - Not found: Dataset xxxxxxxx was not found in location europe-west3”. Is there any workaround to get rid of this error