If it is grayed out, then I suspect it isnt supported (yet). Sharepoint list connector was only recently introduced, so it is likely that this is a limitation.
In here: Note: If the connector you want is not available from the Connect list, cross-database joins are not supported for the combination of sources that you want to join. This includes connections to cube data (e.g., Microsoft Analysis Services), some extract-only data (e.g., Google Analytics, and OData), and Tableau Server data sources. Instead of joining tables, consider using data blending. For more information, see Blend Your Data.
Sorry, I should have posted a separate discussion. Thought will ask you here.
Some one in my organization is trying to connect to Sharepoint Lists. We have a sharepoint site with access to it. I was able to install CDATA driver and test an on premise, it says its successful.
But when I try to connect from Tableau, its giving an error and not connecting. I have tried restarting tableau 10.2, no luck.
I am able to key in the list XML url in the browser and able to load it without any hiccups (integrated auth).
Try connecting to the URL of the site, not the specific list. I was able to connect to the URL of the site and removing /home.aspx to get to the list data for ours
Thank you. I tried the site home page as well, But it does not let me in.
However system DSN shows test successful.
Did someone work successfully with SharePoint 2016 Lists ?
1 of 1 people found this helpful
I had similar issue and I found a workaround to resolve it.
if your test connection is successful, may be your user access is only upto main site and not the sub site. please note, the lists are created under sub sites by default.
Either try to gain access for your user on the sub site ( https://sharepoint.com/MainDocuments/Lists)
Try ODBC as a source and try connect with the CData driver, if you are able to signin you can see all the lists you created including some metadata information.
let me know if you still face the issues. I succeeded this way so it should work for you either