Do you have access to the server administrative views? If so, I'd suggest checking the "Background Tasks for Extracts" view (see Background Tasks for Extracts - Tableau ). This should provide a bit more insight about those refresh jobs.
thank you for your reply. We are using Tableau Online, I have looked at the Tasks tab, but I do not see a history record. All I see is a list of scheduled tasks (daily update i mentioned in my original post) , but no background or history into failure or success of my update attempts.
do you know if there is a similar functionality in Tableau online?
I actually found the background tasks in TO. I noticed that my various attempts keep failing. I get this error message:
Error code 60007, type NAMEOFDATASOURCE of data source is not in the list of types allowed for refresh. Refresh skipped.
* NAMEOFDATASOURCE is a placeholder for the actual data source in Redsift.
Strange. I think you best chance, at this point, would be to open a support case with Tableau.
we finally resolved the issue. if you should encounter this same problem.
Our Redshift data source was joined to an excel spreadhseet. When we attempted the refresh in tableau online, it was looking for the latest excel file, but could not find it, hence the error message and the refresh was skipped.
the solution was to upload the excel file into redshift and join both data sets from Redshift.