BigQuery dataset shown empty

[kbenzakri-lelp]

Hi,

I'm having trouble using BigQuery as a data source because it doesn't detect one of my dataset's content. This dataset contains 502 tables, so I figured that's why tables don't appear unlike other datasets I have. 

Everything works perfectly except for this highly populated dataset.

Thanks for your help

[kbenzakri-lelp · Accepted solution]

Despite the fact that I couldn't display the tables through the BigQuery connector, I've managed to reach these tables.

What I did was importing a radndom table from another BigQuery dataset in the same GCP project. I then entered the model view in order to edit the table (or more precisely the Table Query). I did that by right clicking on the table I imported, clicked on "Edit query", then on the "Advanced Editor" button (which is located in the "Home" tab, in the "Query" part). There, I could change the table name, the dataset name and other parameters.
everything worked well after that

[Anonymous]

Hi @kbenzakri-lelp ,

Does the table contain a lot of blank rows? Are there any error messages reported? Is the problem still there even after reconnecting?

I have also found a similar post, please refer to.

Solved: Connecting data from BigQuery: empty tables - Microsoft Fabric Community

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

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

[kbenzakri-lelp]

Hi @Anonymous,

No PowerBI doesnt even show any tables. As I said, it's a dataset in BigQuery that contains 500+ tables. PowerBI shows 0 table.

When I choose another dataset that contains 10 tables for example, everything works perfectly.

Best regards,

Kamil B.