Unable to refresh dataset due to problems with Bigquery gateways
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