Stuck on evaluating connection to Bigquery (one table works, one table doesn't)

[Mike_woco]

I have two tables in Google BigQuery that I am trying to connect to in Power Bi. Both are on the exact same Google account and within the exact same project in Google Cloud.

The problem that I am having is that Power Bi can connect to the largest table (~5.5M rows, 10 columns) in about 15 seconds, but when I try to connect to the other table, which is significantly smaller (4,000 rows, 14 columns), it gets stuck on "Evaluating ..." while trying to download the table.

I can download both tables just fine in Python using the Google BigQuery API, so I am guessing the problem has to do with Power Bi somehow. Does anyone know what might cause this?

[Anonymous]

Hi @Mike_woco ,

1.You could prolong the timeout in case that the connection need takes more time.

2.Did you do some transformations before loading?

3.How about opening a new PBI application to only connect to the second table? Does the same error occur?

4.I'd suggest you always use the latest version of Power BI Desktop to avoid unexpected errors.

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

[Mike_woco]

Hi @Anonymous 

Thanks for posting:

1. I haven't set a timeout for either of the connections. I didn't fill out any of the advanced options. We once left it on "evaluating" for like an hour, so I don't think there's a timeout set in Power Bi?
   • None of the advanced options have been filled out for the table that works either
2. No data transformations. It's stuck on "evaluating" while trying to fetch the table, so I can't even see the data in PowerBi
   • EDIT: I didn't do any transformation in the actual query either - just realized that was probably what you meant 🙂
3. I tried doing it in a fresh Power Bi application and I still ran in to the same problem. I got two of my colleagues to try it in their Power Bi too and that didn't work either
4. My Power Bi is currently on the July 2022 update

Best regards,

Mike

[paprika96]

Hello, I am stuck on the same problem, it would be very nice if someone had a solution to this!