Forum Discussion
BigQuery dataset shown empty
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
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
3 Replies
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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
