Forum Discussion
BigQuery dataset shown empty
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
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.
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.