Forum Discussion

kbenzakri-lelp's avatar
kbenzakri-lelp
Frequent Visitor
2 years ago
Solved

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 ...
Need Help
Tutorial Requests
  • kbenzakri-lelp's avatar
    kbenzakri-lelp
    2 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    kbenzakri-lelp
    Frequent Visitor
    2 years ago

    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.