When we connect live then data will update, when we open view in server then we can see most recent data.
if we use the extract then we can schedule our workbook and get new updated data.
There are many aspects to this question.
A Tableau Data Extract is a disk-based columnar database snapshot of the Data Source. It has the advantages of being columnar (which provides compression, pre-computed aggregates, and so on), and Tableau can address it directly in vizql without needing a driver to translate vizql into SQL.
A live connection is exactly that; the response time is wholly drive by the upstream data supply's ability to respond to queries in real time.
As for the "automatic" part -- it depends on what you mean. Certainly in a live connection, any interaction with the viz will fire off a query to the data supply to get the current values, whereas an Extract is more of a static snapshot of the data supply unless and until the Extract is Refreshed.
So the real questions become (1) how often is the upstream data updated, and how often does the view need to be updated with the latest ? and (2) which method gives better performance in your environment?
Thanks for the reply.
The affected sheets are no longer showing the error.
However if i have to update the data frequently, is there anyway other way to resolve the error instead of using extract connection?