Unable to refresh dataset due to problems with Bigquery gateways

Based on the last error message 'The table has no visible columns and cannot be queried', have you checked that you the tables can be shown correctly in the data source if you have not connected to it from Power BI Service via the gateway, mostly like the data source error.

Regards

Thanks Anonymous 

Yes it´s a datasource error that we can not refresh nor in local nor in the service . Although queries are working fine, and has data on Bigquery ( nothing changed on these queries or in the datasets, and they worked fine for a long time ) .  

whenever we run for the refresh ( both in the power BI desktop and PBI service on the app ) we have random error messages, always related to the fact that PBI can not connect to Big query . 

Sometimes we gotr error " invalid page token , sometimes "table has no data" , sometimes " the column named whatever doesn´t exist " ....... 

We have follow some reccomendations I saw posted here ( delete cookies, cached , update passwords ....) but looks like the conection with the gateway only working fine for some random periods for only a few minuts 

looks like the conection with the gateway only working fine for some random periods for only a few minuts

Whether there are multiple data sources configured by this gateway are refreshed at the same time range during this 'random periods'

Best Regards,
Community Support Team _ Yingjie Li