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

[v-rongtiep-msft]

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 @v-rongtiep-msft,

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.