Was all the changing between live and extract done in the browser?
In terms of getting the workbook working again as a matter of urgency it might be best to download it, open it in Tableau Desktop and create an extract in Tableau Desktop and republish it.
Thanks for the quick reply. Yes I changed from the browser and it worked fine but when I want to change back it won't let me even if the credentials are right. Is this something I am doing wrong?
The problem is I have made the dashboards available and everyone in the company and it's really slow or does not load for some and I have a demo tomorrow to senior stakeholders and the Live is really slow or doesnt load up at all, so if I change to extract would that work better. I am not familiarised wtith extract, does it have the whole data or does it just take a sample of data as I do not want to show incorrect information. We only update the data in GBQ once a week so will not need live connection, but want to make sure the Extract is the right way and then I refresh the data every time the source is updated.
Any help is appreciated it