Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Unable to refresh dataset due to problems with Bigquery gateways

Good afternoon, Since last week I´m unable to refresh any dataset no matter in local, or in the service. They are datasets used for a long time ago with no changes recently, and since last Monday we are unable to refresh them as always showing different error messages, all related to the unable connection with Big query api Here some examples of errors until now : -(Error 42000 )Invalid page token -Error interacting with rest API : Server returned nothing ( no headers , no data) ERROR HY000. Microsft Bigquery (8701) -DataSource.Error : The table has no visible columns and cannot be queried
Status: Investigating
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

Comments
reports_monica
Regular Visitor

PBI3.PNG

reports_monica
Regular Visitor

PBI1.PNG

liyingjl
Regular Visitor

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

reports_monica
Regular Visitor

Thanks @liyingjl 

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 

 

v-yingjl
Community Support
Status changed to: Investigating
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