Can anyone give me some points to troubleshoot on the above issue
Hey Trinadha K,
Since you are using ODBC I would recommend the "Driver" connection method instead of "DSN".
If you must use a DSN however, then be sure to create your DSN on the Tableau Server as a DSN that the Server "Run As" account can access. I believe a System DSN will suffice, but you may have to create a User DSN when logged in as the same "Run As" account that Server uses.
Are you using some Custom SQL by the way? The message could mean that your data source cannot support subqueries as required by Tableau for Custom SQL. You may be able to override this by setting CAP_QUERY_SUBQUERIES to 'yes' in a customized TDC file, as documented on our Knowledge Base article here: http://kb.tableausoftware.com/articles/knowledgebase/customizing-odbc-connections
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!