BigQuery Dataset Not Showing

[chrishanfp]

Hi everyone,

I am trying to connect Power BI to the BigQuery dataset.

The dataset is shared with me and I only have viewer access.

I tried both:

• Get Data - Database - Google BigQuery
• Get Data - ODBC, using the instruction here (https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers)

I would like to bring in "****world-production" below, but it is not shown when I connect to BigQuery from Power BI.

When I connect to BigQuery from Power BI, only "power-bi-test" shows up in the navigator as below.

Is there something I am doing wrong?

Thank you.

[v-jingzhang]

Hi @chrishanfp 

Not sure if this would help but you may have a try. When using the Google BigQuery connector, expand "Advanced options" and enter the specific project ID information in the "Billing Project ID" or "Project ID" for querying. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.