I'm having the same issue. Did you find any solution or workaround?
Have you been sure to import the WDC in Tableau Server (instructions here: Web Data Connectors in Tableau Server )?
Also - if you install Tableau Desktop onto the same machine as Tableau Server, do you see any different behaviours than on your laptop/desktop computer?
I have indeed imported the WDC using the tabadmin commands. Otherwise Tableau Server doesn't trust the WDC. So then it won't refresh even once.
The second suggestions I haven't tried yet. But I don't immediately see what help it would be.
I'm currently working with Tableau Support to figure it out. I'll keep everyone posted here on my progress
I talked a little bit with Tableau support as well. Google access tokens are short lived (typically only valid for an hour). Access tokens are always issued with a refresh token in the response.
My theory is that the token is valid when you first publish the workbook to server, and might complete the initial extract refresh within the valid token window. When the extract refresh runs again tomorrow (or a few hours later), the token has expired and needs to be refreshed. Tableau server probably tries to use the same expired token again and fails to create a table, which throws the missing table error.
Long story short- it seems that there is no logic in place for the sheets web data connector to check if the token is valid, and use the refresh token accordingly.
It could very well be something like that. But the WDC looks specifically built to support this scenario, and in Tableau Desktop it works fine. We also work with other Google authenticated data sources on our Server, such as Google BigQuery, and that works great.
I've also tried avoiding the oAuth authentication by fully opening the access to my test data in Google Sheets. But even when anyone with the link can view/edit, the WDC still requires me to login.
Eric Templeton is correct on his reasoning about Google Sheets access tokens. That is exactly the reason that the extracts will fail after a certain amount of time. We do not have support for refreshes of Google Sheets that require OAuth. The Google Big Query and Google Analytics OAuth support unfortunately cannot be used for Google Sheets.
But I do have an answer for you about getting a sheet with the right permission set so you don't have to authenticate. Try following the instructions here: View and change published files - Docs editors Help
That should allow you to access the sheet from the WDC without logging in.
This is troubling, thank you for the detailed scenario. Can I ask a few follow up questions to help troubleshoot? I want to help get this sorted out for you. What version of Tableau Server are you running? And are you seeing this behavior with any other connectors? It would be helpful to know if the scenario worked for a connector that didn't need auth.
Here's the details:
9.2.0 (9200.15.1201.0018) 64-bit
Not seeing this with other connectors although those have been quite limited in testing as this was really our first use case for them. I'd have to create or think of another connector we could use for testing.
I'd recommend trying something from the SDK, like the simple StockQuotesConnecotr_final connector.
I'd also recommend trying to find a more detailed error message. Support should be able to help with that. I'd hope that there is a more helpful error message that hints at the problem somewhere lower in the logs.