I pulling data from a single table in an MS Access Database into Tableau. The connection is supposedly LIVE. It does not seem to behave as LIVE becuase when I make updates in the Access database, those changes are not reflected in the data in Tableau. Any idea on what I am doing wrong? What is the difference between an Extract and a LIVE connection? I understood that an Extract would be a static picture of the data and a LIVE connection would constantly be updating as the data updates so my graphs deplicting the data would change as the data changes. I appreciate any assistance you can give me on this one.
Hi Stevan, "Live" is a bit of a misnomer. When you change your database, you then need to save the file, then switch to Tableau and hit F5 (or rt-click the data connection and click Refresh). This will update your data.