1 Reply Latest reply on Feb 21, 2016 6:00 PM by Jeff Strauss

    Maximum DB Fields

    Ananda Theerthan Jagannathan

      Hi,

      I am connecting Tableau with SQL Server. In there, I have an table that contains around 800 columns. Will tableau be able to process all these columns.Is there any limitation on number of fields that Tableau can consume from an source.

      In the end, I am trying to make it as an extract to increase the performance.Please advise.

       

      Regards,

      Anand

        • 1. Re: Maximum DB Fields
          Jeff Strauss

          Hi Ananda.  Typically it's best practice to only pull in the columns from your db that are required to create the viz.  With this best practice in hand, if you have a viz with a lot of columns (i.e. 800), then yes, I believe it's possible to create an extract with this.  It's likely that the extract will take a while to create, but once it's created, then I'm theorizing that the actual rendering of the viz will be unaffected by the # of columns, let me know if this is otherwise.

           

          One suggestion is that when you create an extract, do "hide unused fields" after creating the viz and then run an optimize.  This will allow the extract to be optimized.  See here for more info:  http://kb.tableau.com/articles/knowledgebase/tips-working-with-extracts