Sharepoint List can be connected via Sharepoint List as a source or ODBC as well. After I noticed my user had issues accessing the subsite ( lists ) I tried an alternate to fetch the Lists from Sharepoint. Interestingly I can see Live option enabled ( yet to validate the data)
Step 2: Configure the driver as a system DSN under ODBC drivers ( specify the Sharepoint List URL) to ensure you have the access and connectivity ( though configuring is not mandatory)
is the test connection is successful
Step 3: Go to Tableau Desktop --> sources--> select ODBC--> select CData as driver and hit Connect. This should bring up the encrypted connection string in the String Extras section as show in the below image, now sign in. There you go, you can see CData as a data base ( though its not) hit search button to see the list of views / lists created including many default views.