The table has no visible columns and cannot be queried.. The exception was raised by the IDbCommand

[Anonymous]

Hello everybody,

Since yesterday I have a very blocking problem that I can't solve. The problem appeared from one day to the next without any particular configuration. I have searched the forum for answers to this problem but I have not found anything conclusive.
No dashboard wants to update anymore, all my scheduled updates crash.
I can't create a dashboard by choosing the data source "GOOGLE BIG QUERY", I can find the associated project but when I click on the project, the different datasets of the project are not displayed.

Can you help me to solve this problem, it is very urgent?

DataSource.Error: The table has no visible columns and cannot be queried.. <pii>ALL_XXXX</pii>. ;The table has no visible columns and cannot be queried.. The exception was raised by the IDbCommand interface. Table: ALL_XXXXX.

Thanks in advance

[v-xiaoyan-msft · Accepted solution]

Hi @Anonymous ,

We have submitted to internal ICM 280081207 , engineers are doing their best to fix this issue, please be patient and I will give you feedback here once there is any progress.

Best Regards,
Community Support Team _ Caitlyn

[lbendlin]

looks like your data source uses RLS or OLS and you're no longer "on the list" (you lost your permissions?)

[Anonymous]

Hello,

I use the bigquery connector.

This is strange because I can connect my data with a service account but with my business account I can't.

[1] Do you know how to schedule dashboard updates with a service account?
[2] Is it normal that I can access the data of another project while I have the same rights on GCP in both projects?
I have the following rights:

- BigQuery Data Editor
- BigQuery Data Owner
- BigQuery Job User
- BigQuery Read Session User
- Editor
- Owner