Google BigQuery Data connector: Query execution failed: Cannot parse as CloudRegion.

[zesa1975]

Since the PowerBI Desktop January 2022 Release, I cannot connect with the Google BigQuery Datasource to our GCP tables.

Each time in our environment we get the Error: 

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (20) Query execution failed: Cannot parse as CloudRegion.
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=[Table]

Is that a known issue, and how the CloudRegion can be set from PowerBI side, when the access to the data is etablished?

Thank you in advance for your support and hopefully a solution

[Anonymous]

Hi @zesa1975 ,

I did have similar problem, and apparently in my case, it is caused by wrong Billing Project ID being populated. 

Try to get the correct project ID by going to this link  https://console.cloud.google.com/iam-admin/settings , and take the Project ID specified there, and populate into Billing Project ID.

[Srimahesh]

Hi @zesa1975 - I'm also experiencing similar issue, do you find a solution to fix it? 

[ZIre]

I'm facing the same issue. Are you able to resolve it?

[Anonymous]

Hi @zesa1975 ,

Maybe the following two possibilities caused, you could check:

• The projectId is incorrect or is a non-existing project.

• The authentication credentials are not set up correctly, you could refer to   Solved: Data source credentials - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.