2 Replies Latest reply on Nov 21, 2016 9:27 AM by Michael Hesser

    Optimize Workbook (TWBX) and Access

    Michael Hesser

      How can I optimize my TWBX workbooks when using Access as a source?

       

      I'm currently using just one or two tables from a very large Access database, but converting this into a TWBX duplicates the entire database-- including all those tables, queries, etc, that are unused by Tableau.

      Is there a novice trick I'm overlooking that says "use just the data"?

       

      Do I need to export it out of Access into another form so it can be converted more efficiently?

       

      Because I'm working doing multiple queries through Tableau Desktop (not Server), each extra manual step between platforms reduces productivity and increases the chance of error, not to mention makes me cranky. Please let me know what you think!